public OneToOneQuerySqlServerFixture()
{
_serviceProvider
= new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddInstance <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
var database = SqlServerTestStore.CreateScratch();
var optionsBuilder = new EntityOptionsBuilder();
optionsBuilder.UseSqlServer(database.Connection.ConnectionString);
_options = optionsBuilder.Options;
using (var context = new DbContext(_serviceProvider, _options))
{
context.Database.EnsureCreated();
AddTestData(context);
}
}
public InheritanceSqlServerFixture()
{
_serviceProvider
= new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddSingleton <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
_testStore = SqlServerTestStore.CreateScratch();
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder
.EnableSensitiveDataLogging()
.UseSqlServer(_testStore.Connection);
_options = optionsBuilder.Options;
using (var context = CreateContext())
{
context.Database.EnsureCreated();
SeedData(context);
}
}
protected GraphUpdatesSqlServerFixtureBase()
{
_serviceProvider = new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.BuildServiceProvider();
}
public TransactionSqlServerFixture()
{
_serviceProvider = new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.BuildServiceProvider();
}
public GearsOfWarQuerySqlServerFixture()
{
_serviceProvider = new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddInstance <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
}
public DataAnnotationSqlServerFixture()
{
_serviceProvider = new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddSingleton <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
}
public InheritanceSqlServerFixture()
{
_serviceProvider
= new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddInstance <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
var testStore = SqlServerTestStore.CreateScratch();
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder
.EnableSensitiveDataLogging()
.UseSqlServer(testStore.Connection);
_options = optionsBuilder.Options;
// TODO: Do this via migrations
testStore.ExecuteNonQuery(@"
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 FOREIGN KEY REFERENCES Country (Id),
IsFlightless bit NOT NULL,
EagleId nvarchar(100) FOREIGN KEY REFERENCES Animal (Species),
[Group] int,
FoundOn tinyint,
Discriminator nvarchar(255) NOT NULL
);
CREATE TABLE Plant(
Genus int NOT NULL,
Species nvarchar(100) NOT NULL PRIMARY KEY,
Name nvarchar(100) NOT NULL,
CountryId int FOREIGN KEY REFERENCES Country (Id),
HasThorns bit
);");
using (var context = CreateContext())
{
SeedData(context);
}
}
public NorthwindQuerySqlServerFixture()
{
_serviceProvider
= new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddSingleton <ILoggerFactory>(_testSqlLoggerFactory)
.BuildServiceProvider();
_options = BuildOptions();
}
public NorthwindQuerySqlServerFixture()
{
_serviceProvider
= new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddInstance <ILoggerFactory>(_testSqlLoggerFactory)
.BuildServiceProvider();
_options = BuildOptions();
_serviceProvider.GetRequiredService <ILoggerFactory>().MinimumLevel = LogLevel.Debug;
}
public NullKeysSqlServerFixture()
{
_serviceProvider = new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.BuildServiceProvider();
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer(SqlServerTestStore.CreateConnectionString("StringsContext"));
_options = optionsBuilder.Options;
EnsureCreated();
}
public InheritanceSqlServerFixture()
{
_serviceProvider
= new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddInstance <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
var testStore = SqlServerTestStore.CreateScratch();
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer(testStore.Connection);
_options = optionsBuilder.Options;
// TODO: Do this via migrations & update pipeline
testStore.ExecuteNonQueryAsync(@"
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 FOREIGN KEY REFERENCES Country (Id),
IsFlightless bit NOT NULL,
EagleId nvarchar(100) FOREIGN KEY REFERENCES Animal (Species),
[Group] int,
FoundOn tinyint,
Discriminator nvarchar(255)
);
INSERT Country VALUES (1, 'New Zealand');
INSERT Country VALUES (2, 'USA');
INSERT Animal VALUES ('Aquila chrysaetos canadensis', 'American golden eagle', 2, 0, NULL, 1, NULL, 'Eagle');
INSERT Animal VALUES ('Apteryx owenii', 'Great spotted kiwi', 1, 1, 'Aquila chrysaetos canadensis', NULL, 1, 'Kiwi');
").Wait();
}
public NorthwindQuerySqlServerFixture()
{
_testStore = SqlServerNorthwindContext.GetSharedStore();
_serviceProvider = new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddInstance <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer(_testStore.Connection.ConnectionString);
_options = optionsBuilder.Options;
_serviceProvider.GetRequiredService <ILoggerFactory>()
.MinimumLevel = LogLevel.Debug;
}
public BuiltInDataTypesSqlServerFixture()
{
_testStore = SqlServerTestStore.CreateScratch();
_serviceProvider = new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.BuildServiceProvider();
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer(_testStore.Connection);
_options = optionsBuilder.Options;
using (var context = new DbContext(_serviceProvider, _options))
{
context.Database.EnsureCreated();
}
}
public NorthwindSprocQuerySqlServerFixture()
{
_testStore = SqlServerNorthwindContext.GetSharedStore();
_serviceProvider = new ServiceCollection()
.AddEntityFramework()
.AddSqlServer()
.ServiceCollection()
.AddSingleton(TestSqlServerModelSource.GetFactory(OnModelCreating))
.AddSingleton <ILoggerFactory>(new TestSqlLoggerFactory())
.BuildServiceProvider();
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder
.EnableSensitiveDataLogging()
.UseSqlServer(_testStore.Connection.ConnectionString);
_options = optionsBuilder.Options;
_serviceProvider.GetRequiredService <ILoggerFactory>();
}
