Aggregate functions in LINQ query

1. Avearage – Returns the average value in sequence

2. Count – Returns count of elements in sequence

3. Max – Returns maximum value in sequence

4. Min – Returns minimum value in sequence

5. Sum – Returns sum of values in sequence

6. Aggregate – Computes custom aggregation in sequence

LINQ to ADO.NET

A .NET application can write LINQ queries to SQL, Entities and Dataset. LINQ to SQL and LINQ to Entities have direct connection with Database through ADO.NET layer.

LINQ to ADO.NET

LINQ to ADO.NET

Anonymous Method , Lambda Expressions and LINQ in C# 3.0

LINQ stands for Language Integrated Query.

List contains flower name below  :

List flowerList = new List();
flowerList.Add(“ROSE”);
flowerList.Add(“VIOLET”);
flowerList.Add(“ORCHID”);

LINQ Lists – Anonymous Delegates

string flowerRose = flowerList.Find(delegate ( string flower ) )
{
return flower = “ROSE”;
}
);

LINQ Lists – Lambda Expressions

string roseFlower = flowerList.Find((string flower ) => flower.Equals(“ROSE”));

LINQ Lists – Linq Query

var flowerR = from string flower in flowerList
                    where flower == “ROSE”
                    select flower;