Entities as Linq: Counting takes a long time.

c# entity-framework linq

Question

I need to have parent and parent.child.count()....in the query.. when i do this it is taking 20 seconds....its not a huge database...Any ideas for optimization...

var plist = context.persons
  .Select(p => new
  {
    p.fullName,
    c.personID,
    p.Status,
    p.Birthdate,
    p.Accounts.Count
  }).ToList();
1
3
11/16/2010 9:39:10 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Here is a great article on using count() when you really meant to use any()

http://blogs.teamb.com/craigstuntz/2010/04/21/38598/

4
11/16/2010 8:30:17 PM

Related Questions

Linq to Entities vs. Linq to SQL vs. Entity Framework

I read a lot of articles about how to work with a database in WPF .Net 4 application. As I understood, the main two technologies are:...Linq to SQL (L2S)...Entity Framework (EF)...but sometimes I also can see mention of Linq to Entities (L2E) technology, but can't find clear explanation what difference between EF and L2E....So, my question is: Does...
ado.net entity-framework linq-to-entities linq-to-sql
asked by Mike B.

The LINQ expression node type 'Invoke' is not supported in the entity framework's LINQ to Entities.

can anyone help me out in solving my issue. I am using the code given below:...public IEnumerable<InvoiceHeader> Getdata(Expression<Func<InvoiceHeader, bool>> predicate) { return AccountsContext.InvoiceHeaders.Include("Company").Include("Currency") .Include("BusinessPartnerRoleList").Include("DocumentType") .Where(predicate); } ...
c# entity-framework expression linq predicate
asked by zaheer abbas

LINQ + Entity Framework + "Contains" == Slow as molasses?

This is one of the pitfalls of deferred execution in Linq: In your first approach ...StudentIds... is really an ...IQueryable..., not an in-memory collection. That means using it in the second query will run the query again on the database - each and every time....Forcing execution of the first query by using ...ToArray()... makes ...StudentIds... ...
c# entity-framework linq
asked by BrokenGlass

LINQ-To-Entity (LINQ to Entities does not support the given type member ".)

I am having difficulty understanding this problem:...Here is the T-SQL query I need to implement using LINQ to Entities...select r.ReviewID, b.BusinessID, b.Name as BusinessName ,r.Description from gb_business.Review r inner join gb_business.Business b on r.BusinessID = b.BusinessID inner join gb_listing.RegionalService rs on b.BusinessID = rs.Busi...
c# entity-framework lambda linq-to-entities
asked by itisinteresting

In System.Data.Entity.dll (Entity Framework), why am I receiving a NullReferenceException?

If it's only for Nevada then it must be a data problem, do a thorough check in the db....And to summarize, the core problem was: ...It was db-first. ...... was returning a null value for one of the fields that was marked in EF as not null
c# entity-framework wpf
asked by Henk Holterman

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* Text QK ------> QK* Text Text ...and gives this message if there is any re...
c# count entity-framework group-by linq
asked by Jim S

Error on Cout but i am not using Count in my LINQ exrpression,

I'm not too familiar with EF, but I did come across an ...old msdn post... where someone reported the same bug. They were performing a calculation inside ....Skip()... and to fix it they performed the calculation separately, and just used the result in their LINQ statement....Try calculating ...page * rows... first, then using that result in your L...
asp.net-mvc-5 c# entity-framework-6 linq-to-entities
asked by vivat pisces

Getting COUNT and SKIP TAKE in one operation with Linq to Entities

I have a data call in a Linq to Entities powered data access layer that is designed to make paged calls....In doing so, I need to select a subset of the data, say 50 rows, but also get the count of all matches to know how many total matches exist to be paged through....Currently, I'm doing the following:...var queryResult = DatabaseContext.Table ...
c# entity-framework entity-framework-6 linq sql-server
asked by Wesley

Entity Framework bulk inserts - creating a large number of objects / entities is the slow part?

The slow part in your “creating all the objects” section is the Detect Changes....You should always use AddRange over Add...Add: Detect changes for every object...AddRange: Detect changes only once (after all object are added)...This code should fix the slow part when creating objects:...DataTable ref1 = ConvertCSVtoDataTable(csv, firstRowsToDe...
c# entity-framework entity-framework-6
asked by Jonathan Magnan

Entity Framework Count with a filter on field really slow - large count

When I am running a Model Mapping, one company has a lot of members, like 405,000 members....viewModel.EmployeeCount = company.MembershipUser.Count(x => x.Deleted == false); ...When I run the SQL query, it takes a few milliseconds. In ASP.NET MVC, EF6 C# this can take up to 10 minutes for one list view controller hit. Thoughts?...Company is my Doma...
asp.net-mvc c# entity-framework-6
asked by ransems

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow