LINQ in Action roller

join and group by

Hi NG, a new question about LINQ... I want to convert following SQL Statement to LINQ SQL Snippet SELECT psc.Name ProductSubcategoryName, p.Color FROM Production.ProductSubcategory psc INNER JOIN Production.Product p on psc.ProductSubcategoryID = p.ProductSubcategoryID GROUP BY p.Color, psc.Name ORDER BY psc.Name, p.Color I write following code in C# Code Snippet var query = from psc in prodDtcx.ProductSubcategory join p in prodDtcx.Product on psc.ProductSubcategoryID equals p.ProductSubcategoryID Read More...
Published Saturday, June 2, 2007 6:00 PM by MSDN Forums: LINQ Project General
Anonymous comments are disabled

Featured Item

This Blog