Roadmap › 1. .NET › Step 14
LQ
LINQ — Language Integrated Query
Query vs method syntax, deferred execution, filtering, projection, ordering, grouping, joins, aggregation, set and element operators, IEnumerable vs IQueryable, expression trees, performance and the classic LINQ interview programs.
Interview priority:★ Must know High priority — asked in almost every interview, learn firstMedium asked regularlyLow good to know
Module 1: LINQ Basics
- 1.Query syntax vs method syntaxBasic ★ Must know
- 2.Deferred vs immediate executionBasic ★ Must know
- 3.Filtering, projection and orderingBasic ★ Must know
- 4.Element, quantifier and partitioning operatorsBasic ★ Must know
Module 2: Grouping, Joins and Aggregation
- 5.GroupingIntermediate ★ Must know
- 6.Joins: inner, left, group join, crossIntermediate ★ Must know
- 7.Aggregation and SelectManyIntermediate ★ Must know
- 8.Set operators and generationIntermediate Medium
Module 3: LINQ Internals and EF Core
- 9.IEnumerable vs IQueryableIntermediate ★ Must know
- 10.Expression trees and dynamic queriesAdvanced Medium
- 11.LINQ with EF Core: what translates and common pitfallsAdvanced ★ Must know
- 12.Performance and PLINQAdvanced Medium
Next course in the roadmap: 15. Entity Framework (EF6 & EF Core) →