Devart Forums

Code: Select all

while (true)
{
    using (var conn = new OracleConnection("your connection string"))
    using (var dbContext = new MyDbContext(conn))
        DoQueries(dbContext); // Actual work is irrelevant, as long as this is doing some DB access in order to prime the DbContext
}

Code: Select all

    public class MyDbContext : DbContext
    {
        private readonly IDbConnection _dbConnection;

        public MyDbContext(IDbConnection dbConnection) => _dbConnection = dbConnection;

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            if (!optionsBuilder.IsConfigured)
                optionsBuilder.UseOracle(_dbConnection as DbConnection);
        }
        (...)
    }

Code: Select all

optionsBuilder.UseOracle("your connection string");