public async Task <ActionResult <CustomerDto> > GetCustomersByID(int id) { try { _orm.OpenConn(); var customerDB = await _orm.GetCustomerById(id); var customer = _mapper.Map <CustomerDto>(customerDB); if (customerDB == null) { return(NotFound()); } //Map customer addresses to customer var addressListDB = await _orm.GetCustomerAddressesByCustomerID(id); var addressList = _mapper.Map <List <Customer_AddressesDto> >(addressListDB); customer.Addresses = addressList; await _orm.CloseConn(); return(Ok(customer)); } catch (Exception e) { return(StatusCode(500, e.GetType().Name + ", " + e.Message)); } }