public async Task <Order> GetOrderById(string orderId) { var results = await _database.ExecuteSqlFile("Order/get-order-by-id", new Dictionary <string, object> { { "@order_id", orderId } }); var row = results.First(); return(new Order(row["id"].ToString(), (double)row["Amount"], (double)row["VAT"], (string)row["CustomerId"] )); }