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(); } }