public EmployerFinanceDbContext CreateDbContext() { var optionsBuilder = new DbContextOptionsBuilder <EmployerFinanceDbContext>() .UseSqlServer(_dbConnection) .ConfigureWarnings(w => w.Throw(RelationalEventId.QueryClientEvaluationWarning)); if (_hostingEnvironment.IsDevelopment()) { optionsBuilder.UseLoggerFactory(_loggerFactory); } var dbContext = new EmployerFinanceDbContext(optionsBuilder.Options); return(dbContext); }
public EmployerFinanceDbContext CreateDbContext() { var synchronizedStorageSession = _unitOfWorkContext.Find <SynchronizedStorageSession>(); var sqlStorageSession = synchronizedStorageSession.GetSqlStorageSession(); var optionsBuilder = new DbContextOptionsBuilder <EmployerFinanceDbContext>() .UseSqlServer(sqlStorageSession.Connection) .ConfigureWarnings(w => w.Throw(RelationalEventId.QueryClientEvaluationWarning)); if (_hostingEnvironment.IsDevelopment()) { optionsBuilder.UseLoggerFactory(_loggerFactory); } var dbContext = new EmployerFinanceDbContext(optionsBuilder.Options); dbContext.Database.UseTransaction(sqlStorageSession.Transaction); return(dbContext); }
public static async Task <IEnumerable <AccountTransfer> > GetTransfersByTargetAccountId(this EmployerFinanceDbContext db, long accountId, long targetAccountId, string periodEnd) { var transfers = await db.SqlQueryAsync <AccountTransfer>( "[employer_financial].[GetTransferTransactionDetails] @accountId = {0}, @targetAccountId = {1}, @periodEnd = {2}", accountId, targetAccountId, periodEnd).ConfigureAwait(false); return(transfers); }