public async Task InitializeAsync(Configuration configuration)
{
var connection = configuration.ConnectionFactory.CreateConnection();
await connection.OpenAsync();
try
{
using (var transaction = connection.BeginTransaction(configuration.IsolationLevel))
{
var schemaBuilder = new SchemaBuilder(connection, transaction, TablePrefix);
schemaBuilder.CreateTable("Content", table => table
.Column<int>("Id", column => column
.PrimaryKey().NotNull())
.Column<string>("Content", column => column
.Unlimited()
));
transaction.Commit();
}
}
finally
{
if (configuration.ConnectionFactory.Disposable)
{
connection.Dispose();
}
else
{
connection.Close();
}
}
}