Entity Framework not always get the most update values from the db

Question

I am having a odd problem with EF caching data, and only getting the values as they were when the DB contect is created.

This is a issue as the DB context is injected on the contractor.

I have set LazyLoadingEnabled to be false.

EF has been set up as database first, this will be something that will be changed so it code first.

I am using autofac for the dependency injection.

I know the following demo is odd, but it is the simplest way to explain it.

So if i call the following code, but if i put a break point on every GetFooById I go into the SQL database and change a value in the foo table, it will not load the new changes it will load the values, as they were before I started.

var item1 = _fooService.GetFooById(1);
var item2 = _fooService.GetFooById(1);
var item2 = _fooService.GetFooById(1);

I was wondering how to make EF always get the most update values from the db. My foo service looks like this

private readonly DBEntities _dbContext;

    public FooService(DBEntities  dbContext)
    {
        _dbContext= dbContext;
    }

    public Foo GetFooById(int id)
    {
        return  _dbContext.Foo.First(x => x.Id== id);
    }

The autofac looks like

builder.RegisterAssemblyTypes(ThisAssembly)
  .Where(t => t.Name.EndsWith("Service"))
  .WithParameter("dbContext", new DBEntities())
  .AsImplementedInterfaces();

Please show your DI startup code (expecially the part that registers your DBContext) and indicate what type of application this is (console, WPF, ASP.NET MVC, etc). — NightOwl888
– NightOwl888, Commented Feb 23, 2018 at 21:01
You'd better redesign your service according stackoverflow.com/questions/10777630/… — Horosho
– Horosho, Commented Feb 27, 2018 at 13:59

Cyril Durand · Accepted Answer · 2018-02-24 08:36:05Z

11

You can use the AsNoTracking method disable Entity Framework caching.

public Foo GetFooById(int id)
{
    return  _dbContext.Foo.AsNoTracking().First(x => x.Id== id);
}

See Entity Framework Cache Busting for more information on how to disable cache with Entity Framework

With Entity Framework Core, you can also change this settings at the context level :

context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;

answered Feb 24, 2018 at 8:36

Cyril Durand

16.2k5 gold badges58 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

yu yang Jian · Accepted Answer · 2020-04-01 08:13:16Z

0

yourContext.Entry(yourEntity).Reload();

from this answer.

answered Apr 1, 2020 at 8:13

yu yang Jian

7,2938 gold badges61 silver badges88 bronze badges

Collectives™ on Stack Overflow

Entity Framework not always get the most update values from the db

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related