Tuesday, December 31, 2013

Question about linq to sql query in C#

here is the query



var q =
from c in db.Customers
join o in db.Orders on c.CustomerID equals o.CustomerID
join e in db.Employees on c.City equals e.City
join od in db.Order_Details on o.OrderID equals od.OrderID
join p in db.Products on od.ProductID equals p.ProductID
orderby p.ProductName
select new
{
e.FirstName,
c.ContactName,
od.ProductID,
p.ProductName,
od.UnitPrice,
od.Quantity
};


foreach (var v in q)
{
Console.WriteLine("{0}, {1}, {2}, {3},{4}", v.FirstName, v.ContactName, v.ProductID, v.UnitPrice, v.Quantity);
}





Please mark as answer, if you find this post helpful. Thanks Deepak Kalra


No comments:

Post a Comment