Outof Memory Exception - Linq

Question

I am using LINQ to select bulk data(156000 Records) from DB. But am getting the following error.

An exception of type 'System.OutOfMemoryException' occurred in System.Data.Entity.dll but was not handled in user code

Am using select query as follows,

var allCompanies = from s in db.Data.AsNoTracking().ToList()
                           select s;

Please help me to resolve this issue

By ToList(), you are trying to materialize the whole table in memory. Try selecting just the fields you need, or better still, filter the data before materializing it. — StuartLC
– StuartLC, Commented Mar 12, 2014 at 4:48
Hi stuart, thanks for your response. But if i removed .ToList() then also am getting same error — Sathish
– Sathish, Commented Mar 12, 2014 at 4:50
As an aside, AsNoTracking() will load deep copies of duplicate rows, not sure if this is relevant to your query? — StuartLC
– StuartLC, Commented Mar 12, 2014 at 4:55
Why would you need all those records at once? You can use pagination or process it on the server. — Loetn
– Loetn, Commented Mar 12, 2014 at 7:25
@StuartLC : thanks a lot, i retrived only selected fields. Its working for me — Sathish
– Sathish, Commented Mar 14, 2014 at 5:39

TechnoBrat · Accepted Answer · 2014-03-12 04:53:04Z

2

That is a large amount of records being retrieved. You may need more memory. Have you checked the amount of memory available on your System while this program is executing?

You may want to filter the data or make use of pagination by retrieving certain fixed rows of data at a time.

If it is viable, if you are considering processing the data after retrieving it, you might as well do that in a Stored Procedure.

answered Mar 12, 2014 at 4:53

TechnoBrat

2771 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

Outof Memory Exception - Linq

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related