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