I have been doing some LINQ/DLINQ articles over at codeproject.
Codeproject article link :LINQ Introduction 1 of 3
Heres a small taster of some of the LINQ standard query operators I discuss
in the article (the acticle does them all)
Where
var iSmall =  from it in _itemList  where it.UnitPrice < 50.00M  select it;
Select
var namesAndPrices =
 _itemList.Where(i => i.UnitPrice >= 10).
Select(i => new { i.ItemName,i.UnitPrice }).ToList();
Take
var MostExpensive2 = _itemList. OrderByDescending(i => i.UnitPrice).Take(2);
Join
var itemOrders = from i in _itemList
join o in _orderList on i.ItemID equals o.OrderID
select new { i.ItemName, o.OrderName };
GroupBy
var itemNamesByCategory = from i in _itemList
group i by i.Category into g
select new { Category = g.Key, Items = g };
Intersect
var inter = (from i in _itemList select i.ItemID).Distinct() .Intersect((from o in _orderList select o.OrderID).Distinct());
ToArray
var query = _itemList.ToArray(). Where(i => i.Category.Equals"Food"));
Count
var foodCat = (from i in _itemList
where i.Category.Equals("Food")
select i).Count();
Sum
var totals = (from i in _itemList select i.UnitPrice).Sum();
Thats really only a few of the LINQ standard query operator, there are many many more
mentioned at the article link at the top of this section.
Ive also be doign some DLINQ stuff, and done an article about that as well.
Codeproject article link :DLINQ Introduction 2 of 3
This article discusses the use of the DLINQ designer, the enitity code file generation using the SQLMetal.exe tool,
and also shows some standard DLINQ queries and updates in action
I’ve even attracted the attention of a Mr Joe Rattz, who is just about to publish a LINQ book his blog is here LINQDev.com he liked my articles, as did the totally awesome Marc Clifton. So I must be something right. You decide.
Hope you like them
