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

​

public class Program

{

    public static void Main()

    {

        GenerateData();

        string preparedStatement = "Name == \"Janice Galvin\"";

        var context = new EntityContext();

        var result = context.Customers.Where(c => c.City.Equals("Paris")).ToList();

        FiddleHelper.WriteTable("First Try", result);

        var resultDynamic = context.Customers.Where(preparedStatement).ToList();

        FiddleHelper.WriteTable(resultDynamic);

    }

​

    public static void GenerateData()

    {

        var list = new List<Customer>();

        list.Add(new Customer()

        {Name = "Terri Lee Duffy", CompanyName = "ABC", City = "Paris"});

        list.Add(new Customer()

        {Name = "Janice Galvin", CompanyName = "XYZ", City = "London"});

        list.Add(new Customer()

        {Name = "Michael Raheem", CompanyName = "DEF", City = "New York"});

        list.Add(new Customer()

        {Name = "Michael Sullivan", CompanyName = "ABC", City = "Paris"});

        list.Add(new Customer()

        {Name = "Rebecca Bradley", CompanyName = "KLM", City = "Tokyo"});

        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 ID

        {

            get;

            set;

        }

​

        public string Name

        {

            get;

            set;

        }

​

        public string CompanyName

        {

            get;

            set;

        }

​

        public string City

        {

            get;

            set;

        }

    }

}