EntityFramework. OutOfMemoryException

Question

I have objects graph approximately ~80K records.

When I call SaveChanges I have an OutOfMemoryException. I've been reading about separating saveChanges in batches, but I've don't know how to do it. The trouble that I have in the context chanegd data from 7 tables and there is no straight hierarchy.

How to solve the issue?

Tom Squires · Accepted Answer · 2011-07-13 13:59:44Z

1

My advice would be to use a stored procedure. You could try breaking up your data into groups and and changing each individually but it will be inelegant and prone to bugs. Stored procedures will also be much faster which could have a significant affect considering you are using a large dataset.

answered Jul 13, 2011 at 13:59

Tom Squires

9,31612 gold badges51 silver badges76 bronze badges

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

Collectives™ on Stack Overflow

EntityFramework. OutOfMemoryException

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related