Tagged Questions

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages.

learn more… | top users | synonyms

3
votes
2answers
127 views

Sorting by patients' name or birth

Is there a way to write this simpler? ...
-1
votes
2answers
60 views

Sorting array with respect to two properties

I'm sorting with respect to Width and Length. However, Width has the significance ...
5
votes
1answer
493 views

Sudoku Solver - Recursive Solve

Any ideas on making my code a bit more clean and efficient? Any criticism is appreciated. I don't like that I'm calling my lengthy DeepCopy method so many times, ...
3
votes
1answer
39 views

Parent with N-Childs where each child can have N-Childs

I know my question sounds strange but I have a situation in which I have Parent Data which can have 'N' Childs and each child can further have N-Childs and so on. So its Like. Parent a. Child ...
2
votes
2answers
61 views

Linq C# pulling from table row into input fields

Today is the first time I've used Linq, so I wanted to get a code review on this and make sure I'm going about it correctly. I'm filling text boxes and dropdown lists from a table row. ...
0
votes
1answer
78 views

Approximate integral in one line of code

This is what I came up with: Version 1: ...
1
vote
1answer
69 views

LINQ method to create objects of different types

I have the following code inside a method: ...
5
votes
3answers
85 views

Summing some datum for requests in each domain that fall in a date range

I have a LINQ query which works fine. I am however very interested to understand if this can be written in a more optimum way... ...
0
votes
0answers
40 views

Linq to SQL ('select * from table').Count() vs (“select column from table”).Count() [migrated]

I am writing some linq queries where I came across following scenario: I want to fetch records from DB using Linq bases on some filter Here I want to take all record count also, so I did like ...
17
votes
2answers
204 views

Wait, is this… LINQ?

Context I'm working on a little project that consists in a series of Microsoft Excel add-ins (.xlam). The code being submitted for review here, is located in the ...
2
votes
2answers
113 views

Improving the performance of Linq based solution

Again, out of fun on saturday night, I decided to solve the following problem from CodeEval. The challenge is finding the index of the lowest unique number. ...
3
votes
1answer
68 views

Insert missing records in a list with LINQ

We have a table with periods, and other child tables with these periods and values for combinations of product + location. Based on selected periods, I would like to add any missing rows in the child ...
3
votes
1answer
92 views

Efficiency of nested LINQ foreach loops

I've been working on an older project with framework is 3.5 as the target. There is a new user control that displays a list of data from a web service. I hit the web service (Soap/XML) and deserialize ...
8
votes
3answers
298 views

Indentation on a long (ish) linq chain

I have some code that loops through directories named for years (e.g. /2011/, /2012/ etc) which each contain files whose names ...
5
votes
2answers
96 views

Longer LINQ Chaining

Anyone have ideas on how to improve this code at all? ...
0
votes
0answers
36 views

Looking for a more efficient way to perform this query [closed]

The following query works, but there must be a more efficient way to get the data needed. I'm looking for the sales from a complete client listing for a specific user for last year and this year. ...
-2
votes
2answers
135 views

Optimizing nested loop for an array within a list [closed]

How can I optimize the following code, with LINQ or some other trick? Bird is a class which has different properties id, name, etc and Nest which is an array of places. ...
4
votes
1answer
92 views

Returning a list of income for a month

My current code takes 2.7-4.5 seconds to complete, is there any way to make it faster? I need to return a list of the income in all days in a month. My idea was to loop through the days of one ...
2
votes
1answer
143 views
2
votes
1answer
161 views

LINQ query using StartsWith and Contains to limit the results for an autocomplete field

As a source for a jquery-ui autocomplete field, I've written this action: ...
3
votes
1answer
90 views

Find the number of Colleges offering Combinations of Levels: Performance

I have been using entity framework 5 as DataAccess layer for my application. I have a case where there are a set of Levels offered. And I have a set of ...
11
votes
2answers
384 views

CSV reader using StreamReader and LINQ

Mostly due to readability, I am using the following code to find a specific csv file on a drive read that CSV file using a streamReader parse it into a ...
-1
votes
0answers
47 views

Optimizing searching and comparisons [closed]

There are big words, small words and "rarity" of the small wards. I have to find for each small word that big words, which starts with this small word. And take 10 of them with top rarity. I ...
5
votes
1answer
95 views

Producing the intersection of several sequences

Based on this SO answer I have created a method that produce the set intersection of several sequences: ...
3
votes
1answer
135 views

Compare / Join two object collections LINQ

I have two csv files that I need to compare and merge together. There is a 'big' list with many records and columns of data and a 'small' list of the desired records and some additional data. The ...
4
votes
2answers
77 views

Is this the optimal way to write “find these IDs in a list of objects” using linq?

I've got a situation where I have a list of Organizations (code to follow), and a user has a list of OrganizationIds (ints). I ...
0
votes
3answers
120 views

Linq query performs poor according to performance analyzer in VS2012

I've a Linq query that performs poorly: ...
5
votes
1answer
87 views

Optimize code block for LINQ and non LINQ

I have 2 code block to do same a work and have same target create some thing, but I don't know which block is the best (I mean LINQ or non-LINQ)? First of all, can anyone tell me how to optimize on ...
7
votes
2answers
156 views

Convert a list of sets into the minimum list of non-intersecting sets

I have a list of sets. The same items may appear in multiple sets. I want to transform this into a new list of sets where: Each item only appears once in the entire list of sets. For each set in ...
1
vote
1answer
69 views

Improving iterative manipulation on XML elements

In this reply, there's an example of how to remove a node from a XML structure. ...
1
vote
1answer
192 views

Dynamic Linq from string with EF

I wrote an EF browser to dynamically navigate through entities. Beside basic properties of system types, each entity can have several singular or plural navigation properties. In order to support all ...
2
votes
1answer
115 views

Tasks and WaitAll\WhenAll

Could you help me to speed up/optimize this code: ...
1
vote
4answers
95 views

Checking if there are tags or categories in the database

The code below is used to check if there are tags or categories in the database. If they exist, they are not added to the database, otherwise they are added. Is this code efficient and easy to read? ...
13
votes
3answers
847 views

Using C# properties for simple operations, where should I draw the line?

Should I be putting Linq statements inside of an objects properties? Is that a best practice or is that a no no? Also if that is ok, where do I draw the line with this? I assume db access is ...
2
votes
1answer
47 views

Is there a better way to handle multiple join statements in a linq query? [closed]

I am rewriting a VB.NET app into C#. I won't subject you to the original code. I am mainly looking for a better way to handle all the join statements that are being done. I am dealing with a legacy ...
10
votes
1answer
101 views

Refactor VB.NET to C#.Net using Linq

I am rewriting a VB.NET application in C#. I will not subject you to the original code because it's pretty messy. Below is the converted C# code: ...
4
votes
4answers
328 views

A better way to do LINQ projections

I was wondering if there's a better way of doing LINQ projections than what I'm doing below. This method is one of many methods creating a view of an object tree. The first thing that I don't like is ...
3
votes
1answer
44 views

Updating properties and states

I am rewriting a VB.NET application in C#. This code was originally done in 50 lines and I am trying to clean it up. As you can see I have gotten it down to 10 but I still feel its ugly. I want to ...
3
votes
1answer
77 views

Changing these two functions into one function

I have two functions that are similar. The only differences is that they're using two different models. How can I change them into one function? ...
5
votes
1answer
79 views

ListBox Update Handling

I have UserGroups for Users to be assigned to in a ListBox in HTML form. Items from listbox can be multi-selected or completely ...
7
votes
3answers
184 views

Searching all diagonals of a 2D M x M array

I've started writing a piece of code to help me search for an object in all the objects found in the diagonals of an M x M 2D array. Though the code works, I'd like to know if there is a way I can ...
1
vote
1answer
97 views

Making an email text-parser generic using PredicateBuilder

I have some code that reads an email from a text file, parses the text, removes some lines (the 'cc' and 'to' lines) and then finds the line numbers of various phrases (e.g. "Regards", "Thanks") and ...
3
votes
1answer
66 views

Optimisation XML handling within vb.net application

I need to optimize this snippet to be faster: ...
10
votes
1answer
792 views

Update first and last item in List<T>

I am trying to do the following. I have a list of Custom objects: ...
4
votes
3answers
487 views

Refactor C# Linq code to reduce duplication

I currently have the below code: ...
5
votes
1answer
66 views

EF query for calculating monthly trends

My application has a fairly important query that is used in a lot of places. Unfortunately it takes about 14 seconds to run, so I'd like to find a way of possibly improving it. The application ...
4
votes
1answer
189 views

IndexOrDefault that functions like FirstOrDefault

I don't know why this is not in the .NET Library, but I need to be able to use an index against a list and not have it throw an exception if it is outside the bounds of the list. This is what I came ...
6
votes
4answers
186 views

Simplify LINQ to Create Step Values

Assume the following definition: ...
7
votes
4answers
365 views

File text searcher

I have a working version of a logfile searcher that targets a specific directory by extension type, and searches the files for certain words. I'm wondering if my method is the most efficient ...
5
votes
1answer
107 views

Nested LINQ Nightmare, calculating %completed

This code horrifies and scares me. I wrote this. ...