C#•3w ago

✅ EF Core - Not getting updated data from PostgreSQL table

I have the following method in my DbService.cs

public async Task<long?> GetLastDumpTimeStamp(string endpoint)
{
    using (var context = await _dbContextFactory.CreateDbContextAsync())
    {
        DumpHistory? history = await context.DumpHistory.AsNoTracking().Where(row => row.Endpoint == endpoint).FirstOrDefaultAsync();
        return history?.LastUpdate;
    }
}

public async Task<long?> GetLastDumpTimeStamp(string endpoint)
{
    using (var context = await _dbContextFactory.CreateDbContextAsync())
    {
        DumpHistory? history = await context.DumpHistory.AsNoTracking().Where(row => row.Endpoint == endpoint).FirstOrDefaultAsync();
        return history?.LastUpdate;
    }
}

Which returns a unix timestamp from a postgres table. However if I manually change the data in the column to a completely different number and call the method again I still get the old value prior to my manual change, even after restarting my app. Am I doing something wrong?

5 Replies

Spaxter•3w ago

I've tried logging the output, and this is what I get

Spaxter•3w ago

But this is the row in the database

Spaxter•3w ago

I've tried manually disposing the context and changing to await using ( but none of those worked either

ffmpeg -i me -f null -•3w ago

either you are connecting (or you edited) to the wrong db (happens for example with vpns), to the wrong schema, wrong table, or you have a mock somewhere

Spaxter•3w ago

Aright, turns out DBeaver which I'm using for editing the table was lying to me when it said the data was updated. After invalidating and reconnecting I saw that the value had in fact not changed. Changing the value with the psql CLI worked, thanks.

Gaming

Programming

✅ EF Core - Not getting updated data from PostgreSQL table