using System.Data.SqlServerCe;
public int OrderDetailID { get; set; }
public int OrderID { get; set; }
public int ProductID { get; set; }
public int Quantity { get; set; }
public static void Main()
string sql = "SELECT TOP 10 * FROM OrderDetails";
using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf"))
var orderDetails = connection.Query<OrderDetail>(sql).ToList();
Console.WriteLine(orderDetails.Count);
FiddleHelper.WriteTable(orderDetails);