Dynamic LINQ - Knowledge Base (KB)

Dynamic Linq Group By

I am currently building reports and have a need to Group columns dynamically, depending on user's choice. Now, assuming that the situation is fixed on all columns, the query would be as follows:...var groupedInvoiceItems = invoiceItems.GroupBy(x => new { ...

C# LINQ - How to build Group By clause dynamically

I am working on the application where user can select columns he/she wants to see on the screen and which columns to group by or aggregate. So, in my LINQ section I should actually pass variables that hold column names to both group by and aggregate clau...

EF Select records distinct by one field from Entity

I need to "translate" this code sample:...using var db = new MyDbContext(); var simple_linq = db.USERS.GroupBy(u => u.id_employee).Select(u => u.FirstOrDefault()).ToList(); //it's worked fine for me ...to same code with Dynamic LINQ. I've try:...var dynam...