i.e. string[] cities = { "London", "Paris", "Seattle" }; var query = dataContext.Customers.Where (c => cities.Contains (c.City)); LINQ to SQL gives this error: NotSupportedException: Queries with local collections are not supported It should instead convert this query to: select * from customers where City in ('London', 'Paris', 'Seattle')
Read More...