Entity Framework Core - Knowledge Base (KB)

Can calling ToList on a DbSet cause caching?

I was using the following code to repopulate an ...ObservableCollection<T>... on change notification from a ...SqlDependency...:...var set = _dbContext.Set<T>().ToList(); this.AddRange(set); ...In this scenario, the ...OnChange... event fires correctly, b...

Why does Entity Framework 6.x not cache results?

Perhaps I am misunderstanding the caching that ...DbContext... and ...DbSet... does but I was under the impression that there was some caching that would go on. I'm seeing behavior that I wouldn't expect when I run the following code:...var ctx = CreateAC...

How to detach entity from context when you no longer have a context reference

I am pre-loading product data on my website as I need this to be accessible fast and would rather this be loaded once on application start up rather than just when it's request. This is one way to make sure things load fast. I do this by eager loading my ...

Exclude certain entities from second-level caching

I'm using ...EFCache... to provide 2nd-level caching in my EF context....I ran into a problem, where one of my entities is connected to a view which provides row-level security. So this view filters rows based on some parameters. When using 2nd-level cach...

How can I view the Entity Framework LINQ query plan cache?

I'm having issues with slow LINQ query compilation in EF6. I know EF caches the compiled query plans for LINQ queries, but that there are some gotchas (e. g. Enumerable.Contains prevents caching). I'd like to view the cache for debugging purposes to valid...

How do I reload a model in Entity Framework 7?

I've read that in previous versions of the entity framework, you had access to a ...Reload()... method, like this: ...Db.Entry<DatabaseModels.User>(_me).Reload();...I get an error from that saying that EntityEntry does not contain a definition for 'Reload...

Entity Framework second level cache

I want to use ...EntityFramework.Cache... for one of my tables, but I can not find any information about how does it work with live data and relationships?...I want to know if I add some data to my table or the relation tables does it understand it and re...

Entity Framework flexible cache

I am looking for a cache system that works with Entity Framework 6+. Either to find a suitable library or implement it myself....I have already investigated these two open source cache providers:...Second Level Cache for Entity Framework 6.1 ...https://ef...

Entity Framework 6. Disable ModelCaching

OK, Google, I am not able to googling it. ...Documentation... says...The model for that context is then cached and is for all further instances of the context in the app domain. This caching can be disabled by setting the ModelCaching property on the give...

Entity Framework - how to cache and share read-only objects

We have an application with a fairly complex entity model where high-performance and low-latency are essential but we have no need for horizontal scalability. The application has a number of event sources in addition to a self-hosted ASP.NET Web API 2. ...

Do we need external caching mechanism while EF 6 use caching out of the box?

I recently exposed to Entity Framework 6 ...caching mechanism.... As we might figure from ...this article..., it does it in First-Lever manner....Our system uses EF 6 (code first) along with ...MemoryCache... to improve performance....The main reason we u...

EF Core 2.0.0 Query Filter is Caching TenantId (Updated for 2.0.1+)

I'm building a multi-tenant application, and am running into difficulties with what I think is EF Core caching the tenant id across requests. The only thing that seems to help is constantly rebuilding the application as I sign in and out of tenants....I t...

Caching entity itself in IMemoryCache in ASP.NET Core MVC with Entity Framework

In an ASP.NET Core MVC app I'm using ...IMemoryCache... in ...ConfigureServices()...:...services.AddMemoryCache(); ...In a controller, I originally had this code:...// List<> of POCOs: var myLines = await _context.MyEntity.Where(somecondition).ToListAsync...