Please enable JavaScript.
Coggle requires JavaScript to display documents.
LINQ (Join (Join - Query ("equal") & Method Syntax,…
LINQ
Join
Join - Query ("equal") & Method Syntax
Composite Key Join - anonymous type
GroupJoin for Hierarchical Data
Aggregating (see also Aggregate with seed)
LINQ Queries
yield return (inside Operators)
Deferred Execution = Lazy => tanks to yield return
Execute Query- Count, First, Last, FirstOrDefault, ToList, ToDictionary, ToLookup, ToArray, Any, All, Contains => return mostly List<T>, int, bool
Deferred - where, take => returns mostly IEnumarable<T>
Deffered Operators
Streaming Operators
- Where - zwraca każdy po koleji
Non-Streaming Operators
- OrderBy, OrderByDescending -przechodzi najpier po wszystkich elementach
TODO - sprawdz kolejność WHERE i ORDERBY
search in google: "Classification of standard linq operators"
Projection, Anonymous Types - > Select, SelectMany
LINQ in Entity Framework
IEnumerable - in Memory
IQuerable - translates Expresssion Data Structure to SQL
call ToList() to avaoid multiple DB calls when you are going to use query many times
Query Syntax vs Method Syntax
Method Syntax (Count, Take, Skip)
XML
Functional Construction
Extension Method (LINQ Operators are extension methods)
Lambda Expression
Implicit Typing - var
IEnumerable<out T>
Named Method, Anonymous Method (delegate), Lambda Expression
Func<in,out> , Action<in>