// Dynamic LINQ

// Doc: https://linq-dynamic.net/expression-language

​

// @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.Dynamic.Core;

public class Program

{   

    public static void Main()

    {

        GenerateData();

        using (var context = new EntityContext())

        {

            var list = context.Customers.Where("City = @0", "Paris").ToList();

            FiddleHelper.WriteTable("Customers", list);

        }

        using (var context = new EntityContext())

        {

            var list = context.Customers.Where("it.City = @0", "London").ToList();

            FiddleHelper.WriteTable("Customers using 'it' keyword", list);

        }

​

    }

    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"            

        });

        list.Add(new Customer()

        {

            Name = "Janice Galvin",

            CompanyName = "XYZ",

            City = "London",

            Phone = "333-555555",

        });

​

        list.Add(new Customer()

        {

            Name = "Michael Raheem",

            CompanyName = "DEF",

            City = "New York",

            Phone = "111-555555",            

        });

​

        list.Add(new Customer()

        {

            Name = "Michael Sullivan",

            CompanyName = "ABC",

            City = "Paris",

            Phone = "333-888888",

        });

​

        list.Add(new Customer()

        {

            Name = "Rebecca Bradley",

            CompanyName = "KLM",

            City = "Tokyo",

            Phone = "333-666666",

        });

​

        using (var context = new EntityContext())

        {

            context.Customers.AddRange(list);

            context.BulkSaveChanges();

        }

    }

    public class EntityContext : DbContext

    {

        public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())

        {

​

        }

        public DbSet<Customer> Customers { 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; }

    }

}