Breaking News: Grepper is joining You.com. Read the official announcement!

c# entity framework group by

Grigoris Kokozides answered on June 25, 2022 Popularity 9/10 Helpfulness 5/10

answer c# entity framework group by

c# entity framework group by

Comment

// This works only in .NET 2.1 or lower
db.Clients.AsNoTracking()
 .Include(x => x.Purchases)
 .Where(x => x.Id == id)
 .GroupBy(x => x.PurchaseId)
 .ToList()
  
// For .NET 3.1 or higher you won`t be able to use GroupBy as in the query above
// Instead you have to convert your query to an enumerable
 db.Clients.AsNoTracking()
 .Include(x => x.Purchases)
 .Where(x => x.Id == id)
 .AsEnumerable() // Retrieves the data and groups them in C#
 .GroupBy(x => x.PurchaseId)
 .ToList()
  
// Or an other technique is to use SelectMany
 db.Clients.AsNoTracking()
 .Include(x => x.Purchases)
 .Where(x => x.Id == id)
 .Select(x => x.Purchases.Id)
 .SelectMany(key => db.Purchases
  .Where(y => y.Id == key))
 .ToList()

Popularity 9/10 Helpfulness 5/10 Language csharp

Source: Grepper

Tags: c# entity-framework group-by

Link to this answer
Share Copy Link

Contributed on Jun 25 2022

Grigoris Kokozides

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

c# entity framework group by

Contents

More Related Answers

c# entity framework group by

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.