Huge Memory Issue in Entity framework Load Method

Question

 this.Context.TestPRepetitions.Where(tp => sampleCodes.Contains(tp.SampleCode))  
                .Include(tp => tp.ReportableResults)  
                .Load();  
  
 this.Context.Recognitions.Where(rec => reportableResultIds.Contains(rec.ReportableResultId)).Load();  

Recognitions Table has 6352014 Rows

@AgaveJoe this what the Actual Method Does...

Answer 1

Don’t use Load(). It’s whole point is to load all the rows into memory, and uses lots of memory.