public GraphUpdatesNpgsqlFixture()
{
_serviceProvider = new ServiceCollection()
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.BuildServiceProvider();
}
public ComplexNavigationsQueryNpgsqlFixture()
{
_serviceProvider = new ServiceCollection()
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.AddSingleton <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
}
public NorthwindQueryNpgsqlFixture()
{
_serviceProvider
= new ServiceCollection()
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.AddSingleton <ILoggerFactory>(_testSqlLoggerFactory)
.BuildServiceProvider();
_options = BuildOptions();
}
public NullKeysNpgsqlFixture()
{
_options = new DbContextOptionsBuilder()
.UseNpgsql(NpgsqlTestStore.CreateConnectionString("StringsContext"))
.UseInternalServiceProvider(new ServiceCollection()
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.BuildServiceProvider())
.Options;
EnsureCreated();
}
public NullKeysNpgsqlFixture()
{
var name = "StringsContext";
var connectionString = NpgsqlTestStore.CreateConnectionString(name);
_options = new DbContextOptionsBuilder()
.UseNpgsql(connectionString, b => b.ApplyConfiguration())
.UseInternalServiceProvider(new ServiceCollection()
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.BuildServiceProvider())
.Options;
_testStore = NpgsqlTestStore.GetOrCreateShared(name, EnsureCreated);
}
public override DbContextOptions BuildOptions(IServiceCollection additionalServices = null)
=> ConfigureOptions(
new DbContextOptionsBuilder()
.EnableSensitiveDataLogging()
.UseInternalServiceProvider((additionalServices ?? new ServiceCollection())
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.AddSingleton <ILoggerFactory>(_testSqlLoggerFactory)
.BuildServiceProvider()))
.UseNpgsql(
_testStore.ConnectionString,
b =>
{
ConfigureOptions(b);
b.ApplyConfiguration();
}).Options;
public BuiltInDataTypesNpgsqlFixture()
{
_testStore = NpgsqlTestStore.CreateScratch();
var serviceProvider = new ServiceCollection()
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.BuildServiceProvider();
_options = new DbContextOptionsBuilder()
.UseNpgsql(_testStore.Connection)
.UseInternalServiceProvider(serviceProvider)
.Options;
using (var context = new DbContext(_options))
{
context.Database.EnsureCreated();
}
}
public OneToOneQueryNpgsqlFixture()
{
_testStore = NpgsqlTestStore.CreateScratch();
_options = new DbContextOptionsBuilder()
.UseNpgsql(_testStore.ConnectionString)
.UseInternalServiceProvider(new ServiceCollection()
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.AddSingleton <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider())
.Options;
using (var context = new DbContext(_options))
{
context.Database.EnsureCreated();
AddTestData(context);
}
}
public BuiltInDataTypesNpgsqlFixture()
{
_testStore = NpgsqlTestStore.CreateScratch();
/*
* // TODO: find a better way to do this
* _testStore.ExecuteNonQuery("CREATE TYPE some_composite AS (some_number int, some_text text)");
* var npgsqlConn = (NpgsqlConnection)_testStore.Connection;
* npgsqlConn.ReloadTypes();
* npgsqlConn.MapComposite<SomeComposite>();
*/
var serviceProvider = new ServiceCollection()
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.BuildServiceProvider();
// We need the database to be created with NpgsqlDatabaseCreator for the
// extension migration operations to take place. Drop the database created
// above by NpgsqlTestStore and recreate.
var tempOptions = new DbContextOptionsBuilder()
.UseNpgsql(_testStore.Connection)
.UseInternalServiceProvider(serviceProvider)
.Options;
// Close the test store's connection because the database is about to
// get dropped (via a different master connection)
_testStore.Connection.Close();
using (var context = new DbContext(tempOptions))
context.Database.EnsureDeleted();
_options = new DbContextOptionsBuilder()
.UseNpgsql(_testStore.ConnectionString)
.UseInternalServiceProvider(serviceProvider)
.Options;
using (var context = new DbContext(_options))
context.Database.EnsureCreated();
}
public InheritanceNpgsqlFixture()
{
var serviceProvider = new ServiceCollection()
.AddEntityFrameworkNpgsql()
.AddSingleton(TestNpgsqlModelSource.GetFactory(OnModelCreating))
.AddSingleton <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
_testStore = NpgsqlTestStore.CreateScratch();
_options = new DbContextOptionsBuilder()
.EnableSensitiveDataLogging()
.UseNpgsql(_testStore.Connection)
.UseInternalServiceProvider(serviceProvider)
.Options;
using (var context = CreateContext())
{
context.Database.EnsureCreated();
SeedData(context);
}
}
