public async Task CreateDuplicateStoredProceduresAsync()
{
string createSchemaSql = _sqlQueryBuilder.BuildCreateSchemaQuery();
string sqlQueryCreateFirstStoredProcedure =
_sqlQueryBuilder.BuildCreateStoredProcedureQuery(StoredProcedureTesterTestsConsts
.TestUnoptimisedStoredProcedureName, string.Empty, _sqlQueryBuilder.BuildSelectQuery("1", "Column1"));
string sqlQueryCreateSecondStoredProcedure =
_sqlQueryBuilder.BuildCreateStoredProcedureQuery(StoredProcedureTesterTestsConsts
.TestOptimisedStoredProcedureName, string.Empty, _sqlQueryBuilder.BuildSelectQuery("1", "Column1"));
using (SqlConnection connection = new SqlConnection(StoredProcedureTesterTestsConsts.ConnectionString))
{
SqlCommand createUnoptimisedStoredProcedure = new SqlCommand(sqlQueryCreateFirstStoredProcedure, connection);
SqlCommand createOptimisedStoredProcedure = new SqlCommand(sqlQueryCreateSecondStoredProcedure, connection);
SqlCommand createSchema = new SqlCommand(createSchemaSql, connection);
await connection.OpenAsync();
await createSchema.ExecuteNonQueryAsync();
await createUnoptimisedStoredProcedure.ExecuteNonQueryAsync();
await createOptimisedStoredProcedure.ExecuteNonQueryAsync();
}
}
