7-1-2011 8:20:0
[code]
public void Linq1()
{
int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };

var lowNums =
from n in numbers
where n < 5
select n;

Console.WriteLine("Numbers < 5:");
foreach (var x in lowNums)
{
Console.WriteLine(x);
}
}

[/code]

Result

Numbers < 5:
4
1
3
2
0

7-1-2011 8:20:55
[code]
public void Linq2()
{
List<Product> products = GetProductList();

var soldOutProducts =
from p in products
where p.UnitsInStock == 0
select p;

Console.WriteLine("Sold out products:");
foreach (var product in soldOutProducts)
{
Console.WriteLine("{0} is sold out!", product.ProductName);
}
}
[/code]

7-1-2011 8:22:31
Toán tử select

[code]public void Linq6()
{
int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };

var numsPlusOne =
from n in numbers
select n + 1;

Console.WriteLine("Numbers + 1:");
foreach (var i in numsPlusOne)
{
Console.WriteLine(i);
}
}
[/code]

7-1-2011 8:23:33
Sắp xếp

[code]
public void Linq28()
{
string[] words = { "cherry", "apple", "blueberry" };

var sortedWords =
from w in words
orderby w
select w;

Console.WriteLine("The sorted list of words:");
foreach (var w in sortedWords)
{
Console.WriteLine(w);
}
}
[/code]

7-1-2011 8:25:3
Sắp xếp giảm dần

[code]
public void Linq32()
{
double[] doubles = { 1.7, 2.3, 1.9, 4.1, 2.9 };

var sortedDoubles =
from d in doubles
orderby d descending
select d;

Console.WriteLine("The doubles from highest to lowest:");
foreach (var d in sortedDoubles)
{
Console.WriteLine(d);
}
}
[/code]

7-1-2011 8:27:48
Nối bảng

[code]
public void Linq102()

{

string[] categories = new string[]{

"Beverages",

"Condiments",

"Vegetables",

"Dairy Products",

"Seafood" };



List<Product> products = GetProductList();



var q =

from c in categories

join p in products on c equals p.Category

select new { Category = c, p.ProductName };



foreach (var v in q)

{

Console.WriteLine(v.ProductName + ": " + v.Category);

}

}
[/code]

Kết quả

Chai: Beverages
Chang: Beverages
Guaraná Fantástica: Beverages
Sasquatch Ale: Beverages
Steeleye Stout: Beverages
Côte de Blaye: Beverages

7-1-2011 8:29:14
Nói chung code con linq này cũng chẳng dễ hơn code T-SQL (transaction structure query language) nên, ai thích dùng LINQ thì dùng, còn mình mình vưỡn khoái SQL hơn, nó là ngôn ngữ chung của 1 loạt các DB khác nhau.

Tìm hiểu chi tiết tại đây

http://msdn.microsoft.com/en-us/vcsharp/aa336746