public Booking SelectStandardBookingById(int id) { const string sqlText = @"SELECT Id, [Name], debit_account_id, credit_account_id FROM StandardBookings WHERE Id = @Id"; Booking standardBooking = new Booking(); using (SqlConnection conn = GetConnection()) { using (OpenCbsCommand select = new OpenCbsCommand(sqlText, conn)) { select.AddParam("@Id", id); using (OpenCbsReader reader = select.ExecuteReader()) { while (reader.Read()) { standardBooking.Id = reader.GetInt("Id"); standardBooking.Name = reader.GetString("Name"); Account account = _chartOfAccounts.GetAccountById(reader.GetInt("debit_account_id")); standardBooking.DebitAccount = account; account = _chartOfAccounts.GetAccountById(reader.GetInt("credit_account_id")); standardBooking.CreditAccount = account; } } } } return standardBooking; }