I have an NET Core API and I need to select data from database for my report page.
The data is updating by other applications and I need to read always updated data from db.

But I couldn’t force EF to always get updated data from database. How can I do?

Repository.cs

 protected readonly OracleDbContext _dbContext;

 public EventSuppressRepository(OracleDbContext dbContext)
        {
            _dbContext = dbContext;
        }

public async Task<List<Holiday>> GetSuppressedEventsAsync(){
   List<Holiday> list = _dbContext.Holidays.FromSql(OracleScripts.selectSql).ToList();
   .
   .
   return list; // it returns old data    
}

OracleDbContext.cs

public class OracleDbContext : Microsoft.EntityFrameworkCore.DbContext
    {
        public OracleDbContext()
        {

        }

        public OracleDbContext(DbContextOptions<OracleDbContext> options)
            : base(options)
        {
        }
        
         public DbSet<Holidays> Holidays { get; set; }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {

        }

    }