Saturday, September 4, 2010

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