Esempi in C# (CSharp) per SFA.DAS.CommitmentsV2.Data ProviderCommitmentsDbContext

Esempio n. 1

File: DbContextFactory.cs Progetto: uk-gov-mirror/SkillsFundingAgency.das-commitments

        public ProviderCommitmentsDbContext CreateDbContext()
        {
            var optionsBuilder = new DbContextOptionsBuilder <ProviderCommitmentsDbContext>()
                                 .UseSqlServer(_dbConnection)
                                 .UseLoggerFactory(_loggerFactory)
                                 .ConfigureWarnings(w => w.Throw(RelationalEventId.QueryClientEvaluationWarning));

            var dbContext = new ProviderCommitmentsDbContext(optionsBuilder.Options);

            return(dbContext);
        }

Esempio n. 2

File: SynchronizedDbContextFactory.cs Progetto: uk-gov-mirror/SkillsFundingAgency.das-commitments

        public ProviderCommitmentsDbContext CreateDbContext()
        {
            var synchronizedStorageSession = _unitOfWorkContext.Find <SynchronizedStorageSession>();
            var sqlStorageSession          = synchronizedStorageSession.GetSqlStorageSession();

            var optionsBuilder = new DbContextOptionsBuilder <ProviderCommitmentsDbContext>()
                                 .UseSqlServer(sqlStorageSession.Connection)
                                 .UseLoggerFactory(_loggerFactory)
                                 .ConfigureWarnings(w => w.Throw(RelationalEventId.QueryClientEvaluationWarning));

            var dbContext = new ProviderCommitmentsDbContext(optionsBuilder.Options);

            dbContext.Database.UseTransaction(sqlStorageSession.Transaction);

            return(dbContext);
        }