EntityFramework 6 out of memory exception

dbset entity-framework-6

Question

Hej,

I have a table in database that holds compressed large size file.

when I try to read that file via a Ef6. It throws an out of memory exception.

Any help would be appreciated.

My code is like 

var payload = repositoryContext.Set<DocumentStore>()  
  .Include(document => document.DocumentStorePayloadData)
  .Single(document => document.Id == 
documentStoreId).DocumentStorePayloadData;``
1
0
9/18/2017 12:29:19 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

If you are running this in Visual Studio with debug, I think it only runs as 32 bit. If you have IIS running in 64-bit on your machine, see if you can run via that instead of via the debugger. Otherwise, you only have 2 gb total ram which could cause problems trying to load a 500 meg file.

0
9/20/2017 4:32:14 PM

Related Questions

How do I fix an Entity Framework out of memory exception?

these below codes give whole data of my Rehber datas. But if i want to show web page via Gridview send me out of memory exception error....GenoTip.BAL:... public static List<Rehber> GetAllDataOfRehber() { using (GenoTipSatisEntities genSatisCtx = new GenoTipSatisEntities()) { ObjectQuery<Rehber> ...
.net asp.net c# entity-framework visual-studio-2008
asked by loki

EntityFramework and in memory collection are linked.

You can read how you can do this with the PredicateBuilder from the LINQKit or Stored Procedures in my blog post....http://kalcik.net/2014/01/05/joining-data-in-memory-with-data-in-database-table/
c# entity-framework join linq linq-to-entities
asked by Anton Kalcik

EntityFramework Exception : New transaction is not allowed because there are other threads running in the session

Look at this . This should solve your issues if its similar....Entity Framework Exception
c# entity-framework exception sql-server wpf
asked by Tabish Sarwar

An unhandled exception of type 'System.TypeInitializationException' occurred in EntityFramework.dll

Check which version of Entity Framework reference you have in your References and make sure that it matches with your ...configSections... node in ...Web.config... file. In my case it was pointing to version 5.0.0.0 in my configSections and my reference was 6.0.0.0. I just changed it and it worked......<section name="entityFramework" type="System.D...
.net c# entity-framework sqlite
asked by Hector Alvarez

Entity framework large data set, out of memory exception

I am working the a very large data set, roughly 2 million records. I have the code below but get an out of memory exception after it has process around three batches, about 600,000 records. I understand that as it loops through each batch entity framework lazy loads, which is then trying to build up the full 2 million records into memory. Is there ...
c# entity-framework
asked by Mike Norgate

A first chance exception of type 'System.Data.Entity.Core.EntityCommandExecutionException' occurred in EntityFramework.SqlServer.dll

I just had the same error and I managed to fix it!...This error could be a result of other reasons, but the reason for this error was that the SQL server was not configured to accept transport from my debugging station- I had to configure the IP of my computer in the Sql server settings and then it worked perfectly....Hope it helps.
asp.net-mvc-5 entity-framework-6
asked by Eking

C# Entity Framework high memory usage, memory leak?

I've got a small MVC webapplication running using Entity Framework 6. When starting the application by browwsing to the homepage (eg. www.mywebsite.dev) on my dev. machine the applicationpool get's started and the page get loaded as expected....Despithe the fact that the homepage is pretty ligthweight and only get's a few things from the database (...
asp.net-mvc c# entity-framework memory memory-leaks
asked by Rob

C# Entity Framework 6: Out Of Memory when it absolutely should not run out of memory

I've simplified things as much as possible. This is reading from a table that has around 3,000,000 rows. I want to create a Dictionary from some concatenated fields of the data....Here's the code that, in my opinion, should never, ever throw an Out Of Memory Exception:...public int StupidFunction() { var context = GetContext(); int skip = 0...
c# entity-framework-6 out-of-memory
asked by urbadave

EntityFramework, DbContextScope and Effort - exception: DbContext has been disposed inside unit test

I am trying to write unit tests (with NUnit) for service layer which uses:...Entity Framework as Data Access Layer...DbContextScope... for managing DbContext lifetime...I also use ...Effort.EF6... for mocking DbContext in unit tests. Unfortunately, I cannot find a way to make DbContextScope compatibile with Effort so that I can correctly test all c...
c# dbcontext effort entity-framework unit-testing
asked by PJDev

Huge memory Consumption (MVC 5 + EntityFramework 6.2.0 )

I am having some concerns about my project using a lot of memory. I have configured my MVC 5 project with Entity Framework. I also use Autofac. ...I locate my repository classes and service classes (which are in the same project) by doing:...builder.RegisterAssemblyTypes(typeof(PlanRepository).Assembly) .Where(t => t.Name.EndsWith("Repo...
autofac c# entity-framework entity-framework-6
asked by user9647280

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