public virtual IEnumerable <Order> GetOrders() { var resultOrders = new List <Order>(); using (var connection = connectionDB.CreateConnection()) { using (var command = connection.CreateCommand()) { command.CommandText = "select OrderID, OrderDate, ShipName, ShipAddress, ShippedDate from dbo.Orders"; command.CommandType = CommandType.Text; using (var reader = command.ExecuteReader()) { while (reader != null && reader.Read()) { resultOrders.Add(mappingObject.MapReaderToObject <Order>(reader)); } } } } return(resultOrders); }