Entity Framework 6 - Knowledge Base (KB)

How To Count Associated Entities Without Fetching Them In Entity Framework

I've been wondering about this one for a while now, so I thought it would be worth using my first Stack Overflow post to ask about it....Imagine I have a discussion with an associated list of messages:...DiscussionCategory discussionCategory = _repository...

How to get row number via LINQ using Entity framework?

Hope someone can help me out here as I'm a little stuck....I'm building a service in front of a hiscore database for a game....The database have the following two tables:...CREATE TABLE [dbo].[PB_HiscoreEntry] ( [Id] UNIQUEIDENTIFIER NOT NULL...

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

Group and Count in Entity Framework

I have a table with Logs and I am counting the Logs per day as follows:...// Count logs by day IList<DataModel> models = _context.Logs .Where(x => x.Created >= dateMinimum && x.Created <= dateMaximum) .GroupBy(x => new { Year = x.Created.Year, Month =...

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* ...