Query a SQL Server table with multiple variables using LINQ and C# and return the results

Question

I want to search using multiple criteria and for every "discovery" to save to an object. I found a solution for multiple criteria here

But how can I save every find? The example uses a var and probably will only find one row but what happens when you have multiple rows that match your criteria and want to save them all? Should I use foreach?

You'll have to store your results into a `List` and return that list, if you expect more than one row to be matched — marc_s, Sep 01 '15 at 08:52

score 0 · Answer 1 · answered Sep 01 '15 at 09:26

0

You would need something like this

myvariable.Where(x => x.id == list.id && (y => y.otherfield)).Select( x => x.somethingelse));

answered Sep 01 '15 at 09:26

Simon Price

3,011
3
34
98

Query a SQL Server table with multiple variables using LINQ and C# and return the results

1 Answers1