Entity Framework 6 - Knowledge Base (KB)

GROUP and SUM in Entity Framework

I want to select sum of all (paid) prices of an order item for each customer. Here is SQL command: ...SELECT c.name,SUM(oi.price * oi.count) from customer c JOIN order o ON c.id=o.customer_id JOIN order_item oi ON o.id=oi.order_id JOIN bill b ON b.id=oi.b...

SQL to Entity Framework Count Group-By

I need to translate this ...SQL... statement to a ...Linq-Entity... query......SELECT name, count(name) FROM people GROUP by name

LINQ to Entities group by and Count()

I have the following LINQ-to-Entities query...from r in ctx.Rs join p in ctx.Ps on r.RK equals p.RK group r by r.QK into gr select new { QK = (int)gr.Key, Num = gr.Count() } ...that runs against this schema...Table P Table R Table Q PK* RK ----> RK* ...

Group By Query with Entity Framework

In my application I have ...Movements... associated with a ...category.... I want a list of the most frequent ...category.... ...My objects are: ...Category...: ...catId..., catName ...Movement...: Movid, movDate, movMount, ...catId...I think it would h...

Entity Framework : Group by and Join

I need to get some statistics from the database, but I can't get it to work as I want. I have two tables, Task and Status, and I need to get the number of Tasks per Status, for example, if I have the statuses New and Closed, and each Task has exactly one ...

How to use Group By with Join and Min in Linq

I have two tables....Order:...ID...ProductID...DeliveryDate...Product:...ID...Name...Description...I want to get the list of all product with earliest delivery date....I am getting correct data by using following sql. This gives me list of all products wi...