using System.Data.SqlClient;
using System.Collections.Generic;
public int OrderDetailID { get; set; }
public int OrderID { get; set; }
public int ProductID { get; set; }
public int Quantity { get; set; }
public Order Order { get; set; }
public int OrderID { get; set; }
public int CustomerID { get; set; }
public int EmployeeID { get; set; }
public DateTime OrderDate { get; set; }
public int ShipperID { get; set; }
public OrderDetail OrderDetail { get; set; }
public static void Main()
string sql = "SELECT TOP 10 * FROM Orders AS A INNER JOIN OrderDetails AS B ON A.OrderID = B.OrderID;";
using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))
var orderDetails = connection.QueryAsync<Order, OrderDetail, Order>(
order.OrderDetail = orderDetail;
splitOn: "OrderDetailId").Result.ToList();
Console.WriteLine(orderDetails.Count());
FiddleHelper.WriteTable(orderDetails);