private async Task <string> CreateTemporaryTableAsync(SqlCommand command) { var tableName = "#TempTable" + Guid.NewGuid().ToString().Replace('-', '0'); command.Parameters.Clear(); command.CommandText = ListBlockQueryBuilder.GetCreateTemporaryTableQuery(tableName); await command.ExecuteNonQueryAsync().ConfigureAwait(false); return(tableName); }
private string CreateTemporaryTable(SqlCommand command) { var tableName = "#TempTable" + Guid.NewGuid().ToString().Replace('-', '0'); command.Parameters.Clear(); command.CommandText = ListBlockQueryBuilder.GetCreateTemporaryTableQuery(tableName); command.ExecuteNonQuery(); return(tableName); }
private async Task PerformBulkUpdateAsync(SqlCommand command, string tableName) { command.Parameters.Clear(); command.CommandText = ListBlockQueryBuilder.GetBulkUpdateBlockListItemStatus(tableName); await command.ExecuteNonQueryAsync().ConfigureAwait(false); }
private void PerformBulkUpdate(SqlCommand command, string tableName) { command.Parameters.Clear(); command.CommandText = ListBlockQueryBuilder.GetBulkUpdateBlockListItemStatus(tableName); command.ExecuteNonQuery(); }