public async Task <string> InvokeIbmDb2QueryAsync(string tableName) { var teamMembers = new List <string>(); using (var connection = new DB2Connection(Db2Configuration.Db2ConnectionString)) { connection.Open(); using (var command = new DB2Command("SELECT LASTNAME FROM EMPLOYEE FETCH FIRST ROW ONLY", connection)) { using (var reader = await command.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { teamMembers.Add(reader.GetString(reader.GetOrdinal("LASTNAME"))); } } } var insertSql = string.Format(InsertHotelDB2Sql, tableName); var countSql = string.Format(CountHotelDB2Sql, tableName); var deleteSql = string.Format(DeleteHotelDB2Sql, tableName); using (var command = new DB2Command(insertSql, connection)) { var insertCount = command.ExecuteNonQueryAsync(); } using (var command = new DB2Command(countSql, connection)) { var hotelCount = command.ExecuteScalarAsync(); } using (var command = new DB2Command(deleteSql, connection)) { var deleteCount = command.ExecuteNonQueryAsync(); } } return(string.Join(",", teamMembers)); }
public async Task <int> ExecuteNonQueryAsync() { return(await _cmd.ExecuteNonQueryAsync()); }