private static async Task ExecMsSql(IScenario scenario, string connectionString)
{
var connection = new SqlConnection(connectionString);
using var database = new SqDatabase <SqlConnection>(
connection,
(conn, sql) => new SqlCommand(sql, conn),
TSqlExporter.Default,
disposeConnection: true);
await scenario.Exec(new ScenarioContext(database, SqlDialect.TSql));
}
private static async Task ExecNpgSql(IScenario scenario, string connectionString)
{
var connection = new NpgsqlConnection(connectionString);
using var database = new SqDatabase <NpgsqlConnection>(
connection,
(conn, sql) => new NpgsqlCommand(sql, conn),
new PgSqlExporter(SqlBuilderOptions.Default.WithSchemaMap(new[] { new SchemaMap("dbo", "public") })),
disposeConnection: true);
await scenario.Exec(new ScenarioContext(database, SqlDialect.PgSql));
}
private static async Task ExecMySql(IScenario scenario, string connectionString)
{
ISqDatabase Factory() =>
new SqDatabase <MySqlConnection>(
new MySqlConnection(connectionString),
(conn, sql) => new MySqlCommand(sql, conn),
new MySqlExporter(SqlBuilderOptions.Default),
disposeConnection: true);
using var database = Factory();
await scenario.Exec(new ScenarioContext(database, SqlDialect.MySql, Factory));
}
