LINQ - Home

Home	Table Design

Restriction Operators

Where - Simple 1 Where - Simple 2 Where - Simple 3

Projection Operators

Select - Simple Select - Transformation Select - Anonymous Types 1 Select - Anonymous Types 2 Select - Filtered SelectMany - Compound from 1 SelectMany - Compound from 2 SelectMany - Compound from 3 SelectMany - from Assignment SelectMany - Multiple from

Partitioning Operators

Take – Simple Take - Nested Skip - Simple Skip - Nested

Ordering Operators

OrderBy - Simple 1 OrderBy - Simple 2 ThenBy ThenByDescending OrderByDescending - Simple 1 ThenBy - Simple ThenByDescending - Simple

Grouping Operators

GroupBy - Simple 1 GroupBy - Simple 2

Set Operators

Distinct Union Intersect Except

Conversion Operators

ToArray ToList ToDictionary

Element Operators

First – Simple FirstOrDefault – Simple

Quantifiers

Any – Simple Any - Grouped All - Simple All – Grouped

Aggregate Operators

Count – Simple Count - Conditional Count - Grouped Sum - Simple Sum - Grouped Min - Simple Min - Grouped Max - Simple Max - Projection Max - Grouped Average - Simple Average - Projection Average – Grouped

Miscellaneous Operators

Concat

Join Operator

Inner Join Group Join with Left Outer Join Cross Join with Group Join

==============================================
Shradhdha Zalavadiya |Senior Software Engineer

WebMingle Technology
Accelerated by knowledge. Driven by values.
www.webMingle.in