public async Task TestMethod_UsingSqliteInMemoryProvider_Success()
{
var folder = ScaffoldUtility.JsonDataFolder();
using (var connection = new SqliteConnection("DataSource=:memory:;Foreign Keys = False")) {
connection.Open();
var options = new DbContextOptionsBuilder <FacetContext>()
.UseSqlite(connection) // Set the connection explicitly, so it won't be closed automatically by EF
.Options;
using (var context = JsonSeededFacetContextFactory.Create(options, Fixture)) {
var count = await context.FacetGroups.CountAsync();
Assert.True(count > 0);
var u = await context.FacetGroups.FirstOrDefaultAsync(group => group.FacetGroupKey == "DOMAIN");
Assert.NotNull(u);
Assert.Equal(999, u.FacetGroupId);
}
}
}
public FacetContext CreateFacetContext() => JsonSeededFacetContextFactory.Create(DbContextOptions, Fixture);
