// 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();

        var context = new EntityContext();

        var results = context.Orders.Select( "new (Amount, Price, CustomerName, Month)" ).AsQueryable();

        foreach(var order in results)

        {

            Console.WriteLine(order.Amount.ToString());

        }

        /*

        var averagePrice = context.Orders.Aggregate("Average", "Price");

        Console.WriteLine("averagePrice = {0}", averagePrice);

        var maxAmount = context.Orders.Aggregate("Max", "Amount");

        Console.WriteLine("maxAmount = {0}", maxAmount);

        var minAmount = context.Orders.Aggregate("Min", "Amount");

        Console.WriteLine("minAmount = {0}", minAmount);

        var totalAmount = context.Orders.Aggregate("Sum", "Amount");

        Console.WriteLine("totalAmount = {0}", totalAmount);

        */

    }

    public static void GenerateData()

    {

        var orders = new List<Order>

        {

            new Order { Amount = 5, Price = 3, CustomerName = "Raja", Month = 4 },

            new Order { Amount = 10, Price = 8, CustomerName = "Raja", Month = 4 } 

        };

        using (var context = new EntityContext())

        {

            context.Orders.AddRange(orders);

            context.BulkSaveChanges();

        }

    }

    public class EntityContext : DbContext

    {

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

        {

        }

        public DbSet<Order> Orders { get; set; }

    }

    public class Order

    {

        public int Id { get; set; }

        public int Amount { get; set; }

        public double Price { get; set; }

        public string CustomerName { get; set; }

        public int Month { 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; }

        public string Phone { get; set; }

    }   

}