zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

6 results in tag: group-by

Entity Framework GROUP and SUM

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...
entity-framework group-by linq-to-entities select sum
asked by quin16

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
count entity-framework group-by linq-to-entities sql
asked by fefwfefefwfwe

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* ...
c# count entity-framework group-by linq
asked by Jim S

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...
c# entity-framework entity-framework-6 group-by linq
asked by Migue

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 ...
c# entity-framework-6 group-by join
asked by Hultan

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...
c# entity-framework-6 group-by join linq
asked by Sandip D

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!