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

learn more… | top users | synonyms

8
votes
1answer
74 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: ...
0
votes
0answers
13 views

Deep loading data - MVC / Entity Framework / Repository Pattern [closed]

I am implementing an ASP.NET MVC 5 web app using ASP.NET Identity 2 and Troy Goode's PagedList. I need to display UserRole data in the following format in a JqGrid: User Name | Role Name This ...
4
votes
4answers
275 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
37 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
49 views

Changing these 2 Function into one function

I have two functions that are similar. The only differences is that their using two different models. How can i change them into one function? ...
4
votes
1answer
59 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 ...
6
votes
3answers
73 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
52 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
37 views

Optimisation XML handling within vb.net application

I need to optimize this snippet to be faster: ...
10
votes
1answer
274 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
156 views

Refactor C# Linq code to reduce duplication

I currently have the below code: ...
5
votes
1answer
56 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
150 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
175 views

Simplify LINQ to Create Step Values

Assume the following definition: ...
7
votes
4answers
332 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
93 views

Nested LINQ Nightmare, calculating %completed

This code horrifies and scares me. I wrote this. ...
5
votes
1answer
75 views

Combining List<>.ForEach and List<>.Zip

I have three lists, and I need to operate on the ith element of each list simultaneously. ...
4
votes
1answer
118 views

Convert hex string to byte array

The goal is to convert a hex string to a byte array with the following requirements: \$O(1)\$ additional space apart from input and output. \$O(n)\$ runtime This mostly just prohibits creating a ...
5
votes
2answers
190 views

Efficient way to get every unique combination of “Pick 1 number from each Group of Numbers”

My question is: Using C# and/or Linq, how can this existing code be improved to be more efficient? (My "Complex" example takes about 5 seconds to run, how to make it faster?) What the code is ...
5
votes
2answers
104 views

Adding object to database, using linq or sql connection

I have a table called tblDelegates in my database which I need to populate with some data. I have created a class called Delegates which has various properties to ...
4
votes
2answers
86 views

Create a LINQ Killer Sudoku Cage Solver

When playing Killer Sudoku I find myself repeatedly writing stuff like this: 12/3 921 831 741 732 651 642 543 and then crossing out the combinations that include ...
6
votes
1answer
129 views

Refactoring a LINQ query that (sometimes) returns null

I have the following LINQ query that should return a result for each Request. I'd prefer to have the query translated to ...
6
votes
3answers
314 views

Get distinct combinations of numbers

The below code returns all distinct combinations based on the logic that 1,2,3 = 3,2,1 = 2,3,1, so it only returns 1 instance of that set of numbers. ...
8
votes
2answers
176 views

Take previous element from array if condition on current element matches

Any ideas to simplify this beauty; I would prefer a LinQ expression if possible: ...
6
votes
2answers
332 views

Web service getting value using LINQ from queue table in SQL database

As a test of my C# skills, I have been asked to create a simple web service which will take a message from a queue table in a SQL database and send it to a web application when a button is pressed on ...
2
votes
1answer
68 views

Is there a better way to do this linq sort?

I have the following linq statement that is ordering a list of assets by the sort order of a child item: ...
2
votes
2answers
322 views

Sum(), ForEach() with Lambda in a hierarchical List Collection

I have to list the number of documents related to items in a hierarchical tree. The specification states: The tree will only ever be 2 levels deep. The higher level items will list not only the ...
3
votes
2answers
208 views

Extracting Pixels From Image Byte[]

I have a requirement where I need to extract pixels of a given rectangle within an image byte[]. More specifically I have an image where I have narrowed an area ...
3
votes
3answers
169 views

Test questions - Number Generator, Linq, Delegates, Sequences

I have recently been asked to do a test prior to an interview to test my C# skills. I am fairly new to C# (6 months) and I think this showed with me producing an overly complex answer to their ...
2
votes
2answers
81 views

Mixing Linq queries and Linq lambdas

I have been given a change to rewrite an old framework we use, and to implement the repository and unit of work patterns, but in an attempt to not rewriting all queries I have ended up with a weird ...
4
votes
1answer
405 views

Linq queries performance

I am fetching data from the database using entity framework and linq queries. I am wondering about the performance of getting data. Here is my code. I just want to check that a Well exists in ...
3
votes
2answers
92 views

Copy two properties from one array item to matching index in another array

I have two IEnumerable objects called items and newItems. I need to update the Did and ...
8
votes
4answers
1k views

Single line FizzBuzz solution in LINQ

Now FizzBuzz itself isn't a big challenge but I agree that it can be a good tool to see if someone can code or not. I wanted to practice my LINQ a little bit so here's my single line FizzBuzz ...
2
votes
2answers
150 views

Check database for item and create it if it doesn't exist

Is there a more efficient approach to this code? ...
2
votes
1answer
69 views

Compare Collection with the information in DB using EF and LINQ

I want to inform the Receivers about new contracts we have this week. After I sent the Emails, the Information about sent contracts are stored in MS SQL Database. To avoid that someone become the ...
4
votes
1answer
136 views

EntityFramework-based filtering

I am trying to use the following form to enter new info into a database. I am trying to use the entity framework. I have the following classes of Interest: ...
5
votes
2answers
192 views

Getting list of daily team goals

The old code I had before was atrociously slow but after some advice and research I was able to take a 2-5 minutes run time down to about 5-30 seconds. That is acceptable, but still looking to have ...
5
votes
3answers
170 views

Calculating total sales from each member

I am building a new system that is using some tables from an old system. For each user on this new system, I need to go to the old system and total up their sales. Currently it takes between 2-5 ...
11
votes
6answers
832 views

Increment up the build number in AssemblyInfo.cs on every build

I just wrote this short little program to increment up the build number for my projects every time I build them. After compiling this exe, I just call it in the pre-build command line. I did take ...
4
votes
1answer
97 views

Am I even using the Entity Frameowrk and/or LINQ the way it is supposed to be used?

I feel like just because the below works doesn't mean it is correct, I want to improve it but I can't really figure out how. Besides the fact it is down right ugly I feel the performance could be ...
2
votes
2answers
79 views

Add chat to an MVC database: Can I condense this code and is it appropriately placed?

I have these relevant tables in an MVC website: Server ServerPlayer ServerPlayerChat Servers have serverPlayers, ServerPlayers have ServerPlayerChats. Simple enough and expectable. I'm using ...
10
votes
4answers
516 views

Generate sequence in Linq

I want to generate a sequence using Linq that goes from 10 to 100 with a step size of 10. The sequence also must contain a custom value (in the correct order). This is what I have now, and I'm ...
4
votes
2answers
87 views

Retrieve Tasks by Employee

I think I've done a decent job keeping this query simple and understandable, but I'd like to know if you have some more advice. My relevant entities are defined like this: ...
1
vote
2answers
268 views

Converting Anonymous To Dynamic [closed]

I have a extension method like following that takes Anonymous type objects and returns it after converting into ExpandoObject which falls under ...
6
votes
2answers
154 views

Inversion of an array that contains indices

I have an array of length n that contains numbers from 0 to n-1 in random order. I now want to "inverse" this array to one that where index i corresponds to the location of i in the source array. ...
3
votes
1answer
107 views

Linq sorting on sort order of inner group

Is this the best way to do this sort? ...
5
votes
2answers
909 views

Better method for updating data table

I have completed an application which gathers specific records and marks them as Collected. As of now, the application runs perfectly, does exactly what I need it ...
5
votes
1answer
77 views

Identical linq for different index

I am parsing excel data and need to create object based on StartDate-EndDate difference. Is there a better way to have only one linq perform this task and return two different result sets ? Only ...
6
votes
2answers
459 views

How to determine expiration date based on list of months in which to refresh?

Original question and code block moved to the end because it seems that using a List<int> made the algorithm much easier than my real situation I have a list ...
-2
votes
2answers
119 views

Is this correct way to use loops or should it be in LINQ?

The results variable is coming from an API that have a arrays in arrays, etc. I have made a foreach with ...