Entity Framework efficient use on large datasets

Question

I have a large dataset in my Entity Framework context - table1 and a large List<T>, I need to count same values in the table1/list1 above.

I can do it two different ways:

jointCollection=table1.union(list1) - and to check: the value of list1.count+table1.count-jointCollection.count...
to do count on select table1 with multi condition(list1.count)

My question is which method is more efficient?

Please define "in my context"? Are you trying to be smart by loading the complete table into memory instead of doing what is sensible, i.e. asking the database to count them? — TomTom
– TomTom, Commented Jul 28, 2012 at 8:29
my context is my complete table... guessing by your replay it is not that smart... — user1071420
– user1071420, Commented Jul 28, 2012 at 12:05

Spikeh · Accepted Answer · 2012-07-28 07:59:21Z

3

The best solution is to run SQL profiler while you run each one and find out!

However, if efficiency is paramount, I would recommend using a stored procedure imported in to EF as a function, as Linq to Entities adds additional overhead.

answered Jul 28, 2012 at 7:59

Spikeh

3,7454 gold badges26 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

marc_s Over a year ago

That implies and assumes he's using SQL Server ... which is likely, but not clear from the question.... EF works against other RDBMS systems, too

Collectives™ on Stack Overflow

Entity Framework efficient use on large datasets

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related