Dynamic LINQ - Simple Query

CSharp · Console

/Program.cs

// Dynamic LINQ - stef

// @nuget: System.Linq.Dynamic.Core
// @nuget: Z.EntityFramework.Classic

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.Entity;
using System.Linq.Expressions;
using System.Linq.Dynamic.Core;
					
public class Program
{	
	public static void Main()
	{
		GenerateData();
		
		var context = new EntityContext();
		
		// Example 1: Strongly styped = normal LINQ
		var example1 = context.Customers
			.Where(c => c.City == "Paris");
		FiddleHelper.WriteTable(example1);

		// Example 2: Dynamic
		var example2 = context.Customers
            .Where("City == \"Paris\"")
            .ToList();
		FiddleHelper.WriteTable(example2);
		
		// Example 3: Dynamic
		string cityToSearch = "Paris";
		var example3 = context.Customers
            .Where("City == @0", cityToSearch)
            .ToList();
		FiddleHelper.WriteTable(example3);
	}
		 
	public static void GenerateData()
    {
        List<Customer> list = new List<Customer>();
        list.Add(new Customer()
        {
            Name = "Terri Lee Duffy",
            CompanyName = "ABC",
            City = "Paris",
            Phone = "333-444444",
            Orders = new List<Order>()
            {
                new Order() { Date = DateTime.Today }
            }
        });
        list.Add(new Customer()
        {
            Name = "Janice Galvin",
            CompanyName = "XYZ",
            City = "London",
            Phone = "333-555555",
            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 }
            }
        });

        list.Add(new Customer()
        {
            Name = "Michael Raheem",
            CompanyName = "DEF",
            City = "New York",
            Phone = "111-555555",
            Orders = new List<Order>()
            {
                new Order() { Date = DateTime.Today.AddDays(-4) },
                new Order() { Date = DateTime.Today }
            }
        });

        list.Add(new Customer()
        {
            Name = "Michael Sullivan",
            CompanyName = "ABC",
            City = "Paris",
            Phone = "333-888888",
            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 }
            }
        });

        list.Add(new Customer()
        {
            Name = "Rebecca Bradley",
            CompanyName = "KLM",
            City = "Tokyo",
            Phone = "333-666666",
            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);
            context.SaveChanges();
        }
	}
	
	public class EntityContext : DbContext
	{
		public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())
		{

		}
		
		public DbSet<Customer> Customers { get; set; }
		public DbSet<Order> Orders { get; set; }
	}
	
	
	public class Customer
    {
        public int CustomerID { 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 class Order
    {
        public int OrderID { get; set; }
        public DateTime Date { get; set; }
    }
}
;