using System.Collections.Generic;
using System.Data.Entity;
using System.Linq.Expressions;
using System.Linq.Dynamic.Core;
public static void Main()
var context = new EntityContext();
var example1 = context.Customers
.OrderBy(c => c.City).ThenBy(c => c.CompanyName)
FiddleHelper.WriteTable(example1);
var example2 = context.Customers
.OrderBy("City, CompanyName")
FiddleHelper.WriteTable(example2);
var example3 = context.Customers
.OrderBy("City").ThenBy("CompanyName desc")
FiddleHelper.WriteTable(example3);
var example4 = context.Customers
.OrderBy("City, CompanyName desc")
FiddleHelper.WriteTable(example4);
public static void GenerateData()
List<Customer> list = new List<Customer>();
Name = "Terri Lee Duffy",
Orders = new List<Order>()
new Order() { Date = DateTime.Today }
Orders = new List<Order>()
new Order() { Date = DateTime.Today.AddDays(-25) },
new Order() { Date = DateTime.Today.AddDays(-11) },
new Order() { Date = DateTime.Today.AddDays(-7) },
new Order() { Date = DateTime.Today }
Orders = new List<Order>()
new Order() { Date = DateTime.Today.AddDays(-4) },
new Order() { Date = DateTime.Today }
Name = "Michael Sullivan",
Orders = new List<Order>()
new Order() { Date = DateTime.Today.AddDays(-35) },
new Order() { Date = DateTime.Today.AddDays(-21) },
new Order() { Date = DateTime.Today.AddDays(-17) },
new Order() { Date = DateTime.Today.AddDays(-11) },
new Order() { Date = DateTime.Today.AddDays(-4) },
new Order() { Date = DateTime.Today }
Name = "Rebecca Bradley",
Orders = new List<Order>()
new Order() { Date = DateTime.Today.AddDays(-21) },
new Order() { Date = DateTime.Today.AddDays(-18) },
new Order() { Date = DateTime.Today.AddDays(-10) },
new Order() { Date = DateTime.Today.AddDays(-9) },
using (var context = new EntityContext())
context.Customers.AddRange(list);
public class EntityContext : DbContext
public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())
public DbSet<Customer> Customers { get; set; }
public DbSet<Order> Orders { get; set; }
public int CustomerID { get; set; }
public int Age { get; set; }
public string Name { get; set; }
public string CompanyName { get; set; }
public string City { get; set; }
public string Phone { get; set; }
public List<Order> Orders { get; set; }
public int OrderID { get; set; }
public DateTime Date { get; set; }