I have a EF model with Entities mapped to DB views, and the tables under the views are massive and when I try to query the these entities I get OutOfMemoryException. There must be something possible to fix this.
here is a snippet of the code
Code: Select all
using(ContractEntities ctx = new ContractEntities ())
{
List list = ctx.ContractSet.Where(p => p.SocialSecurityNumber == "1234567890").ToList();
return list;
}