Breaking News: Grepper is joining You.com. Read the official announcement!

Entity Framework 4 and caching of query results

Mappy Show answered on May 6, 2022 Popularity 5/10 Helpfulness 2/10

answer Entity Framework 4 and caching of query results

Entity Framework 4 and caching of query results

Comment

// The EF context will cache "per instance". That is, each instance of the 
// DbContext keeps it's own independent cache of objects. You can store the resulting 
// list of objects in a static list and query it all you like without returning to the 
// database. To be safe, make sure you abandon the DbContext after you execute the query.

var dbContext = new YourDbContext();
StaticData.CachedListOfThings = dbContext.ListOfThings.ToList();

// You can later use LINQ to query the static list.

var widgets = StaticData.CachedListOfThing.Where(thing => thing.Widget == "Foo");

Popularity 5/10 Helpfulness 2/10 Language csharp

Source: stackoverflow.com

Tags: c# caching entity-framework

Link to this answer
Share Copy Link