var q = (from pd in Products
join od in Orders on pd.ProductID equals od.ProductID
orderby od.OrderID
select new
{
od.OrderID,
pd.ProductID,
pd.Name,
pd.UnitPrice,
od.Quantity,
od.Price,
}).ToList();
Sign up here with your email
.Net tips,.Net Interview Tips,Sql Server,Jquery,Javascript notes,AngularJS,Asp.net,Ajax
ConversionConversion EmoticonEmoticon