Category: linq

Linq – How to aggregate the results of another query

I want to take the results of a where clause on a list and then take that result set and create just one new type that has all its fields constructed from aggregates of the original query. So given the basic example below, is there anyway to combine the 2 linq statements into one? If […]

How to dynamically add OR operator to WHERE clause in LINQ

I have a variable size array of strings, and I am trying to programatically loop through the array and match all the rows in a table where the column “Tags” contains at least one of the strings in the array. Here is some pseudo code: IQueryable<Songs> allSongMatches = musicDb.Songs; // all rows in the table […]