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); } }