private static SqliteConnection CreateDatabaseAndGetConnection()
{
var connection = new SqliteConnection("Data Source=:memory:");
connection.Open();
var options = new DbContextOptionsBuilder <CmsDbContext>()
.UseSqlite(connection)
.Options;
using (var context = new CmsDbContext(options))
{
context.GetService <IRelationalDatabaseCreator>().CreateTables();
}
return(connection);
}