public InheritanceSqliteFixture() { _testStore = SqliteTestStore.CreateScratch(); _options = new DbContextOptionsBuilder() .UseSqlite(_testStore.Connection) .UseInternalServiceProvider(new ServiceCollection() .AddEntityFrameworkSqlite() .AddSingleton(TestSqliteModelSource.GetFactory(OnModelCreating)) .AddSingleton<ILoggerFactory>(new TestSqlLoggerFactory()) .BuildServiceProvider()) .Options; // TODO: Do this via migrations & update pipeline _testStore.ExecuteNonQuery(@" DROP TABLE IF EXISTS Country; DROP TABLE IF EXISTS Animal; CREATE TABLE Country ( Id int NOT NULL PRIMARY KEY, Name nvarchar(100) NOT NULL ); CREATE TABLE Animal ( Species nvarchar(100) NOT NULL PRIMARY KEY, Name nvarchar(100) NOT NULL, CountryId int NOT NULL , IsFlightless bit NOT NULL, EagleId nvarchar(100), 'Group' int, FoundOn tinyint, Discriminator nvarchar(255), FOREIGN KEY(countryId) REFERENCES Country(Id), FOREIGN KEY(EagleId) REFERENCES Animal(Species) ); CREATE TABLE Plant ( Genus int NOT NULL, Species nvarchar(100) NOT NULL PRIMARY KEY, Name nvarchar(100) NOT NULL, CountryId int, HasThorns bit, FOREIGN KEY(countryId) REFERENCES Country(Id) ); "); using (var context = CreateContext()) { SeedData(context); } TestSqlLoggerFactory.Reset(); }
public AutoincrementTest() { _testStore = SqliteTestStore.CreateScratch(); var provider = new ServiceCollection() .AddEntityFrameworkSqlite() .BuildServiceProvider(); _options = new DbContextOptionsBuilder() .UseInternalServiceProvider(provider) .UseSqlite(_testStore.Connection) .Options; }
public SqliteDatabaseModelFactoryTest() { _testStore = SqliteTestStore.CreateScratch(); var serviceProvider = new SqliteDesignTimeServices() .ConfigureDesignTimeServices(new ServiceCollection().AddLogging()) .BuildServiceProvider(); var logger = new TestLogger(); serviceProvider.GetService<ILoggerFactory>().AddProvider(new TestLoggerProvider(logger)); _factory = serviceProvider .GetService<IDatabaseModelFactory>() as SqliteDatabaseModelFactory; }
public SqliteScaffoldingModelFactoryTest() { _testStore = SqliteTestStore.CreateScratch(); var serviceProvider = new SqliteDesignTimeServices() .ConfigureDesignTimeServices( new ServiceCollection().AddScaffolding().AddLogging()) .AddSingleton<IFileService, FileSystemFileService>() .BuildServiceProvider(); _logger = new TestLogger(); serviceProvider.GetService<ILoggerFactory>().AddProvider(new TestLoggerProvider(_logger)); _scaffoldingModelFactory = serviceProvider .GetService<IScaffoldingModelFactory>() as RelationalScaffoldingModelFactory; }
public MappingQuerySqliteFixture() { var serviceProvider = new ServiceCollection() .AddEntityFrameworkSqlite() .AddSingleton<ILoggerFactory>(new TestSqlLoggerFactory()) .BuildServiceProvider(); _testDatabase = SqliteNorthwindContext.GetSharedStore(); _options = new DbContextOptionsBuilder() .UseModel(CreateModel()) .UseSqlite( _testDatabase.ConnectionString, b => b.SuppressForeignKeyEnforcement()) .UseInternalServiceProvider(serviceProvider) .Options; }
public override SqliteTestStore CreateTestStore() { return(SqliteTestStore.GetOrCreateShared(DatabaseName, () => { var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseSqlite(SqliteTestStore.CreateConnectionString(DatabaseName)); using (var context = new GraphUpdatesContext(_serviceProvider, optionsBuilder.Options)) { context.Database.EnsureDeleted(); if (context.Database.EnsureCreated()) { Seed(context); } } })); }
public MappingQuerySqliteFixture() { _serviceProvider = new ServiceCollection() .AddEntityFramework() .AddSqlite() .ServiceCollection() .AddSingleton <ILoggerFactory>(new TestSqlLoggerFactory()) .BuildServiceProvider(); _testDatabase = SqliteNorthwindContext.GetSharedStore(); var optionsBuilder = new DbContextOptionsBuilder().UseModel(CreateModel()); optionsBuilder.UseSqlite(_testDatabase.ConnectionString) .SuppressForeignKeyEnforcement(); _options = optionsBuilder.Options; }
public InheritanceSqliteFixture() { _options = new DbContextOptionsBuilder() .UseSqlite(SqliteTestStore.CreateConnectionString("InheritanceSqlite")) .UseInternalServiceProvider(new ServiceCollection() .AddEntityFrameworkSqlite() .AddSingleton(TestModelSource.GetFactory(OnModelCreating)) .AddSingleton <ILoggerFactory>(TestSqlLoggerFactory) .BuildServiceProvider()) .Options; using (var context = CreateContext()) { context.Database.EnsureClean(); SeedData(context); } }
public BuiltInDataTypesSqliteFixture() { _testStore = SqliteTestStore.CreateScratch(); var serviceProvider = new ServiceCollection() .AddEntityFrameworkSqlite() .AddSingleton(TestSqliteModelSource.GetFactory(OnModelCreating)) .BuildServiceProvider(); _options = new DbContextOptionsBuilder() .UseSqlite(_testStore.Connection) .UseInternalServiceProvider(serviceProvider) .Options; using (var context = new DbContext(_options)) { context.Database.EnsureCreated(); } }
public BuiltInDataTypesSqliteFixture() { _testStore = SqliteTestStore.CreateScratch(); var serviceProvider = new ServiceCollection() .AddEntityFrameworkSqlite() .AddSingleton(TestModelSource.GetFactory(OnModelCreating)) .BuildServiceProvider(); _options = new DbContextOptionsBuilder() .UseSqlite(_testStore.Connection) .UseInternalServiceProvider(serviceProvider) .Options; using (var context = new DbContext(_options)) { context.Database.EnsureClean(); } }
public OneToOneQuerySqliteFixture() { var serviceProvider = new ServiceCollection() .AddEntityFrameworkSqlite() .AddSingleton(TestSqliteModelSource.GetFactory(OnModelCreating)) .AddSingleton<ILoggerFactory>(new TestSqlLoggerFactory()) .BuildServiceProvider(); _testStore = SqliteTestStore.CreateScratch(); _options = new DbContextOptionsBuilder() .UseSqlite(_testStore.ConnectionString) .UseInternalServiceProvider(serviceProvider) .Options; using (var context = new DbContext(_options)) { context.Database.EnsureCreated(); AddTestData(context); } }
public OneToOneQuerySqliteFixture() { var serviceProvider = new ServiceCollection() .AddEntityFrameworkSqlite() .AddSingleton(TestModelSource.GetFactory(OnModelCreating)) .AddSingleton <ILoggerFactory>(TestSqlLoggerFactory) .BuildServiceProvider(); _testStore = SqliteTestStore.CreateScratch(); _options = new DbContextOptionsBuilder() .UseSqlite(_testStore.ConnectionString) .UseInternalServiceProvider(serviceProvider) .Options; using (var context = new DbContext(_options)) { context.Database.EnsureClean(); AddTestData(context); } }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder .UseSqlite(SqliteTestStore.CreateConnectionString(DatabaseName)) .UseInternalServiceProvider(_serviceProvider);
public override DbContext CreateContext(SqliteTestStore testStore) => new FindContext(_options);
public override SqliteTestStore CreateTestStore() => SqliteTestStore.GetOrCreateShared(DatabaseName, EnsureCreated);
public override DbContext CreateContext() => new LoadContext(new DbContextOptionsBuilder() .UseSqlite(SqliteTestStore.CreateConnectionString("LoadTest")) .UseInternalServiceProvider(_serviceProvider) .Options);
public SqliteForeignKeyTest() { _testStore = SqliteTestStore.CreateScratch(); }
public SqliteForeignKeyTest() { _testStore = SqliteTestStore.CreateScratch(); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlite(SqliteTestStore.CreateConnectionString(_databaseName)); }