Beispiel #1
0
        public override async Task RunAllAsync()
        {
            string dbId = "EFRepoTestAsync";

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AddAsync(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_GetAsync(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AnyAsync(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefaultAsync(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_RemoveAsync(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AddRangeAsync(uow, 100, 2);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_GetAllAsync(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AllMatchingAsync(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_MaxAsync(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_RemoveRangeAsync(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_RollbackAsync(uow);
            }
        }
 public void Init()
 {
     using (var context = new SqlServerFullContext(Configuration))
     {
         context.DropSchema();
         context.CreateSchema();
     }
 }
 public void Init()
 {
     Options = new DbContextOptionsBuilder <SqlServerFullContext>().UseSqlServer(ConfigurationManager.ConnectionStrings[DbConfig].ConnectionString).Options;
     using (var context = new SqlServerFullContext(Options))
     {
         context.Database.EnsureDeleted();
         context.Database.EnsureCreated();
     }
 }
        public override async Task RunAllAsync()
        {
            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AddAsync(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_GetAsync(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AnyAsync(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefaultAsync(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_RemoveAsync(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AddRangeAsync(uow, 100, 2);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_GetAllAsync(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AllMatchingAsync(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_MaxAsync(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_RemoveRangeAsync(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_RollbackAsync(uow);
            }
        }
Beispiel #5
0
        public static void Init(TestContext tstContext)
        {
            Configuration = Fluently.Configure().Database(MsSqliteConfiguration.Standard.ConnectionString("Data Source=:memory:;cache=shared;mode=memory")).Mappings(
                o => o.FluentMappings
                .AddFromAssemblyOf <Banking.Models.Context.Mappings.NHib.SqlServer.BankAccountMap>()).BuildConfiguration();

            // Keep connection to in-memory db alive for duration of test
            // otherwise the db gets discarded when all connections are closed
            Context = new SqlServerFullContext(Configuration);
            Context.CreateSchema();
        }
        public void Init()
        {
            if (Database.Exists(DbConfig))
            {
                Database.Delete(DbConfig);
                Database.SetInitializer(new DropCreateDatabaseAlways <SqlServerFullContext>());
            }

            using (var context = new SqlServerFullContext(DbConfig))
            {
                context.Database.Initialize(true);
            }
        }
Beispiel #7
0
        public override void RunAll()
        {
            string dbId = "EFRepoTest";

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Add(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Get(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any_WithFilter(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any_WithFilter_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault_WithFilter(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault_WithFilter_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Modify(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Remove(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_GetAll_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_AddRange(uow, 100, 2);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_GetAll(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_AllMatching(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_AllMatching_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_GetAllPaged(uow, 2);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Max(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_RemoveRange(uow);
            }

            using (var uow = new SqlServerFullContext(DbConnectionFactory.CreatePersistent(dbId)))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Rollback(uow);
            }
        }
        public override void RunAll()
        {
            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Add(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Get(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any_WithFilter(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any_WithFilter_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault_WithFilter(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault_WithFilter_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Modify(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Remove(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_GetAll_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_AddRange(uow, 100, 2);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_GetAll(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_AllMatching(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_AllMatching_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_GetAllPaged(uow, 2);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Max(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_RemoveRange(uow);
            }

            using (var uow = new SqlServerFullContext(Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Rollback(uow);
            }
        }
Beispiel #9
0
        public override void RunAll()
        {
            string dbInstance = "EFCORE_Sql";

            this.Options = new DbContextOptionsBuilder <SqlServerFullContext>().UseInMemoryDatabase(dbInstance).ConfigureWarnings(w => w.Ignore(InMemoryEventId.TransactionIgnoredWarning)).Options;

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Add(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Get(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any_WithFilter(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any_WithFilter_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault_WithFilter(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault_WithFilter_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Modify(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Remove(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_GetAll_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Any_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefault_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_AddRange(uow, 100, 2);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_GetAll(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_AllMatching(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_AllMatching_NothingFound(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_GetAllPaged(uow, 2);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Max(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_RemoveRange(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                this.BaseUnitOfWorkUnitTests_BankAccount_Rollback(uow);
            }
        }
Beispiel #10
0
        public override async Task RunAllAsync()
        {
            string dbInstance = "EFCORE_SqlAsync";

            this.Options = new DbContextOptionsBuilder <SqlServerFullContext>().UseInMemoryDatabase(dbInstance).ConfigureWarnings(w => w.Ignore(InMemoryEventId.TransactionIgnoredWarning)).Options;

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AddAsync(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_GetAsync(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AnyAsync(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_FirstOrDefaultAsync(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_RemoveAsync(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AddRangeAsync(uow, 100, 2);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_GetAllAsync(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_AllMatchingAsync(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_MaxAsync(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_RemoveRangeAsync(uow);
            }

            using (var uow = new SqlServerFullContext(this.Options))
            {
                await this.BaseUnitOfWorkUnitTests_BankAccount_RollbackAsync(uow);
            }
        }
Beispiel #11
0
 public static void Cleanup()
 {
     Context?.Dispose();
     Context       = null;
     Configuration = null;
 }