C# linq to sql

Question

In a C# 2010 desktop application I need to write a linq to sql statement that connects to a sql server 2008 R2 database. I need to be able to use a group by for 4 specific columns so that I can the count to be correct. I have been trying to get the group by to work with no success so far. Thus can you show me some code on how to accomplish this goal?

Akkiraju Ivaturi · Answer

var query = (from t in QualityBreakdown group t by new {t.MaterialID t.ProductID} into grp select new { grp.Key.MaterialID grp.Key.ProductID Quantity = grp.Sum(t => t.Quantity) }).ToList(); where QuantityBreakdown is a table name and materialID productID and Quantity are columns of the table. QuantityBreakdown ( MaterialID int ProductID int Quantity float ) The solution is to use: Use an anonymous type. Eg:group x by new { x.Column1 x.Column2 } Let me know if you have any questions.

Akkiraju Ivaturi · Answer

Let me know the table name and columns and also what exactly did you mean by all the code together in one spot?

dc · Answer

Can you show me all the code together in one spot?