Code Snippet posted by:
Vishalbedre | Posted on: 10/10/2012 | Category:
LINQ Codes | Views: 430 | Status:
[Member] |
Points: 40
|
Alert Moderator
Here is the code snippet of Group By using LINQ. IN this we have taken the tables from Northwind database and joined them.
var data = from c in db.Customers
join o in db.Orders
on c.CustomerID equals o.CustomerID
select new
{
CustomerName = c.ContactName,
ORderId = o.OrderID
};
var d = from dd in data
group dd by dd.CustomerName into g
select new
{
cNAme = g.Key,
rCount = g.Count()
};
For more LINQ related methods visit
http://www.dotnetfunda.com/articles/article993-frequently-used-linq-extension-methods.aspx
Thanks