private static async Task RunDatabaseCreationTest(JetTestStore testStore, bool async)
{
using (var context = new BloggingContext(testStore))
{
var creator = context.GetService <IRelationalDatabaseCreator>();
if (async)
{
Assert.True(await creator.EnsureCreatedAsync());
}
else
{
Assert.True(creator.EnsureCreated());
}
Assert.Equal(ConnectionState.Closed, context.Database.GetDbConnection().State);
if (testStore.State != ConnectionState.Open)
{
await testStore.OpenAsync();
}
var tables = testStore.Query <string>("SELECT NAME FROM (SHOW TABLES)");
Assert.Equal(1, tables.Count());
Assert.Equal("Blogs", tables.Single());
var columns = (testStore.Query <string>(
"SELECT Table + '.' + Name + ' (' + TypeName + ')' FROM (SHOW TABLECOLUMNS) ORDER BY Table, Name")).ToArray();
Assert.Equal(14, columns.Length);
}
}
