public SqliteDatabaseProvider()
{
var connectionStringBuilder = new SqliteConnectionStringBuilder { DataSource = ":memory:" };
var connectionString = connectionStringBuilder.ToString();
var connection = new SqliteConnection(connectionString);
var builder = new DbContextOptionsBuilder<TestDbContext>();
builder.UseSqlite(connection);
options = builder.Options;
using (var context = new TestDbContext(options))
{
context.Database.OpenConnection();
context.Database.EnsureCreated();
}
}
public void CanAddEntity()
{
var testEntity = new TestEntity {Id = 1, Name = "Test Entity"};
using (var context = new TestDbContext(options))
{
context.TestEntities.Add(testEntity);
context.SaveChanges();
}
TestEntity foundEntity;
using (var context = new TestDbContext(options))
{
foundEntity = context.TestEntities.FirstOrDefault(x => x.Id == testEntity.Id);
}
Assert.NotNull(foundEntity);
Assert.Equal(testEntity.Name, foundEntity.Name);
}
