Menu
Going backwards from SQL to LINQ2SQL is sometimes quite simple. The following statement
SELECT user FROM users WHERE lastname='jones'
translates fairly easily into
from u in users where u.lastname='jones' select u
But how do you get the following SQL generated?
SELECT user FROM users WHERE lastname IN ('jones', 'anderson')
533
Using the List object Contains method in the Where clause will create the IN T-SQL clause. The code snippet uses the Microsoft Northwind sample database using the Customers table as an example. If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".
The where clause is used in a query expression to specify which elements from the data source will be returned in the query expression. It applies a Boolean condition (predicate) to each source element (referenced by the range variable) and returns those for which the specified condition is true.
Except operator are designed to allow you to query data which supports the IEnumerable<T< interface. Since all LINQ query expressions, and most LINQ queries, return IEnumerable<T<, these operators are designed to allow you to perform set operations on the results of a LINQ query.
LINQ query syntax always ends with a Select or Group clause. The Select clause is used to shape the data. You can select the whole object as it is or only some properties of it. In the above example, we selected the each resulted string elements.
I had to do a bit of searching to find this, and thought it might be useful to others.
List<string> names = new List<string>() { "jones", "anderson" };
from u in users where names.Contains(u.lastname) select u
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With