本文整理汇总了C#中BloggingContext.GetService方法的典型用法代码示例。如果您正苦于以下问题：C# BloggingContext.GetService方法的具体用法？C# BloggingContext.GetService怎么用？C# BloggingContext.GetService使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类BloggingContext的用法示例。
在下文中一共展示了BloggingContext.GetService方法的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Exists_returns_true_when_database_exists_test
private static async Task Exists_returns_true_when_database_exists_test(bool async)
{
using (var testDatabase = await SqlServerTestStore.CreateScratchAsync(createDatabase: true))
{
using (var context = new BloggingContext(testDatabase))
{
var creator = context.GetService<IRelationalDatabaseCreator>();
Assert.True(async ? await creator.ExistsAsync() : creator.Exists());
Assert.Equal(ConnectionState.Closed, context.Database.GetDbConnection().State);
}
}
}示例2: CreateTables_creates_schema_in_existing_database_test
private static async Task CreateTables_creates_schema_in_existing_database_test(bool async)
{
using (var testDatabase = await SqlServerTestStore.CreateScratchAsync())
{
var serviceProvider = new ServiceCollection()
.AddEntityFrameworkSqlServer()
.BuildServiceProvider();
var optionsBuilder = new DbContextOptionsBuilder()
.UseInternalServiceProvider(serviceProvider)
.UseSqlServer(testDatabase.ConnectionString);
using (var context = new BloggingContext(optionsBuilder.Options))
{
var creator = (RelationalDatabaseCreator)context.GetService<IDatabaseCreator>();
if (async)
{
await creator.CreateTablesAsync();
}
else
{
creator.CreateTables();
}
if (testDatabase.Connection.State != ConnectionState.Open)
{
await testDatabase.Connection.OpenAsync();
}
var tables = await testDatabase.QueryAsync<string>("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'");
Assert.Equal(1, tables.Count());
Assert.Equal("Blogs", tables.Single());
var columns = await testDatabase.QueryAsync<string>("SELECT TABLE_NAME + '.' + COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Blogs'");
Assert.Equal(2, columns.Count());
Assert.True(columns.Any(c => c == "Blogs.Id"));
Assert.True(columns.Any(c => c == "Blogs.Name"));
}
}
}示例3: EnsureDeleted_will_delete_database_test
private static async Task EnsureDeleted_will_delete_database_test(bool async, bool openConnection)
{
using (var testDatabase = await SqlServerTestStore.CreateScratchAsync(createDatabase: true))
{
if (!openConnection)
{
testDatabase.Connection.Close();
}
using (var context = new BloggingContext(testDatabase))
{
var creator = context.GetService<IRelationalDatabaseCreator>();
Assert.True(async ? await creator.ExistsAsync() : creator.Exists());
if (async)
{
Assert.True(await context.Database.EnsureDeletedAsync());
}
else
{
Assert.True(context.Database.EnsureDeleted());
}
Assert.Equal(ConnectionState.Closed, context.Database.GetDbConnection().State);
Assert.False(async ? await creator.ExistsAsync() : creator.Exists());
Assert.Equal(ConnectionState.Closed, context.Database.GetDbConnection().State);
}
}
}示例4: RunDatabaseCreationTest
private static async Task RunDatabaseCreationTest(SqlServerTestStore testStore, bool async)
{
using (var context = new BloggingContext(testStore))
{
var creator = context.GetService<IRelationalDatabaseCreator>();
Assert.Equal(ConnectionState.Closed, context.Database.GetDbConnection().State);
if (async)
{
Assert.True(await creator.EnsureCreatedAsync());
}
else
{
Assert.True(creator.EnsureCreated());
}
Assert.Equal(ConnectionState.Closed, context.Database.GetDbConnection().State);
if (testStore.Connection.State != ConnectionState.Open)
{
await testStore.Connection.OpenAsync();
}
var tables = await testStore.QueryAsync<string>("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'");
Assert.Equal(1, tables.Count());
Assert.Equal("Blog", tables.Single());
var columns = (await testStore.QueryAsync<string>(
"SELECT TABLE_NAME + '.' + COLUMN_NAME + ' (' + DATA_TYPE + ')' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Blog' ORDER BY TABLE_NAME, COLUMN_NAME")).ToArray();
Assert.Equal(19, columns.Length);
Assert.Equal(
new[]
{
"Blog.AndChew (varbinary)",
"Blog.AndRow (timestamp)",
"Blog.Cheese (nvarchar)",
"Blog.CupOfChar (int)",
"Blog.ErMilan (int)",
"Blog.Fuse (smallint)",
"Blog.George (bit)",
"Blog.Key1 (nvarchar)",
"Blog.Key2 (varbinary)",
"Blog.NotFigTime (datetime2)",
"Blog.NotToEat (smallint)",
"Blog.On (real)",
"Blog.OrNothing (float)",
"Blog.OrULong (int)",
"Blog.OrUShort (numeric)",
"Blog.OrUSkint (bigint)",
"Blog.TheGu (uniqueidentifier)",
"Blog.ToEat (tinyint)",
"Blog.WayRound (bigint)"
},
columns);
}
}示例5: EnsuredDeleted_noop_when_database_doesnt_exist_test
private static async Task EnsuredDeleted_noop_when_database_doesnt_exist_test(bool async)
{
using (var testDatabase = await SqlServerTestStore.CreateScratchAsync(createDatabase: false))
{
using (var context = new BloggingContext(testDatabase))
{
var creator = context.GetService<IRelationalDatabaseCreator>();
Assert.False(async ? await creator.ExistsAsync() : creator.Exists());
if (async)
{
Assert.False(await creator.EnsureDeletedAsync());
}
else
{
Assert.False(creator.EnsureDeleted());
}
Assert.Equal(ConnectionState.Closed, context.Database.GetDbConnection().State);
Assert.False(async ? await creator.ExistsAsync() : creator.Exists());
Assert.Equal(ConnectionState.Closed, context.Database.GetDbConnection().State);
}
}
}