Linq: What is the difference between Select and Where

by

Where

finds items that match and only returns those that do (filtering).

-> IEnumerable<A> in, IEnumerable<A> out

Select

returns something for all items in the source (projection / transformation). That something might be the items themselves, but are more usually a projection of some sort.

-> IEnumerable<A> in, IEnumerable<B> out

More Related Contents:

  1. “Or” equivalent in Linq Where() lambda expression
  2. LINQ to Entities does not recognize the method
  3. Which method performs better: .Any() vs .Count() > 0?
  4. What is the difference between IQueryable and IEnumerable?
  5. How to do SQL Like % in Linq?
  6. Is it better to call ToList() or ToArray() in LINQ queries?
  7. LINQ to SQL Left Outer Join
  8. Why is LINQ JOIN so much faster than linking with WHERE?
  9. Linq to Entities – SQL “IN” clause
  10. Case insensitive string compare in LINQ-to-SQL
  11. LINQ on the .NET 2.0 Runtime
  12. Wrap a delegate in an IEqualityComparer
  13. How do I get the MAX row with a GROUP BY in LINQ query?
  14. LINQ Single vs First
  15. Why does a Linq Cast operation fail when I have an implicit cast defined?
  16. EF LINQ include multiple and nested entities
  17. .NET List Concat vs AddRange
  18. .NET LINQ query syntax vs method chain
  19. Ignore namespaces in LINQ to XML
  20. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  21. Why use LINQ Join on a simple one-many relationship?
  22. Does LINQ work with IEnumerable?
  23. LINQ, can’t join to string
  24. How to use “contains” or “like” in a dynamic linq query?
  25. Why are some object properties UnaryExpression and others MemberExpression?
  26. How to perform merge sort using LINQ?
  27. Linq to Objects: does GroupBy preserve order of elements?
  28. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  29. How to Convert Row to Column in Linq and SQL
  30. How to return a page of results from SQL?

Leave a Comment