// Entity Framework Classic

// Doc: https://entityframework-classic.net/linq-dynamic

​

// @nuget: Z.EntityFramework.Classic

// @nuget: Newtonsoft.Json

​

using System;

using System.Collections.Generic;

using System.Data.Entity;

using System.Linq;

using System.Linq.Expressions;  

using Newtonsoft.Json;

using Z.Expressions;

​

public class Program

{

    public static void Main()

    {

        DateTime dateStart = DateTime.Now;

        DateTime dateEnd = DateTime.Now.AddDays(1).AddTicks(-1);

        Console.WriteLine(dateStart+ " - "+dateEnd);

        Console.WriteLine(Math.Round(11.351351351351351351351351351m,28,System.MidpointRounding.AwayFromZero));     

        Console.WriteLine(Math.Round(11.351351351351351351351351351m,28,System.MidpointRounding.ToEven));       

        Console.WriteLine(Math.Round(11.351351351351351351351351351m,28,System.MidpointRounding.ToNegativeInfinity));       

        Console.WriteLine(Math.Round(11.351351351351351351351351351m,28,System.MidpointRounding.ToPositiveInfinity));       

        Console.WriteLine(Math.Round(11.351351351351351351351351351m,28,System.MidpointRounding.ToZero));       

        GenerateData();

​

        using (var context = new EntityContext())

        {       

            var query = context.Customers.OrderByDynamic(x => "x.Name");

            query = query.ThenByDynamic(x => "x.Description");

            FiddleHelper.WriteTable("Customers",query.ToList());        

        }

    }

​

    public static void GenerateData()

    {

        using (var context = new EntityContext())

        {

            context.Customers.Add(new Customer() { Name = "Customer_A", Description = "ZZZ Projects"});

            context.Customers.Add(new Customer() { Name = "Customer_A", Description = "Description"});          

            context.Customers.Add(new Customer() { Name = "Customer_B", Description = "Description"});

            context.SaveChanges();  

        }

    }

​

    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 Description { get; set; }

    }

    public class Criteria

    {

        public string Method { get; set; }

        public string Field { get; set; }

        public string Operation { get; set; }

        public string Value { get; set; }

        public string Expression { get; set; }

    }

}