Learn LINQ (Language-Integrated Query)

Learn LINQ

Language-Integrated Query (LINQ) is a powerful set of technologies based on the integration of query capabilities directly into the C# language. LINQ Queries are the first-class language construct in C# .NET, just like classes, methods, events. The LINQ provides a consistent query experience to query objects (LINQ to Objects), relational databases (LINQ to SQL), and XML (LINQ to XML).

Basics

  1. What is LINQ
  2. Why LINQ
  3. LINQ API
  4. LINQ Query Syntax
  5. LINQ Method Syntax
  6. Lambda Expressions in LINQ
  7. Define Expressions in LINQ
  8. Expression Tree in LINQ
  9. Deferred Execution of LINQ Queries
  10. Immediate Execution of LINQ Queries
  11. let Keyword
  12. into Keyword
  13. Sample C# LINQ Queries
  14. LINQ Learning Resources
LINQ Test
LINQ Tests

LINQ Standard Query Operators

  1. Standard Query Operators
  2. Where
  3. OfType
  4. OrderBy
  5. ThenBy
  6. GroupBy, ToLookup
  7. Join
  8. GroupJoin
  9. Select
  10. All, Any
  11. Contains
  12. Aggregate
  13. Average
  14. Count
  15. Max
  16. Sum
  17. ElementAt, ElementAtOrDefault
  18. First, FirstOrDefault
  19. Last, LastOrDefault
  20. Single, SingleOrDefault
  21. SequenceEqual
  22. Concat
  23. DefaultIfEmpty
  24. Empty, Range, Repeat
  25. Distinct
  26. Except
  27. Intersect
  28. Union
  29. Skip, SkipWhile
  30. Take, TakeWhile
  31. Conversion Operators