// 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 takeTwoCustomers = context.Customers.OrderBy("CustomerID").Take(2);

        FiddleHelper.WriteTable(takeTwoCustomers);

        var takeWhile = context.Customers.ToList().AsQueryable().TakeWhile("CompanyName != \"ZZZ\"");

        FiddleHelper.WriteTable(takeWhile);

    }

    public static void GenerateData()

    {

        var order1 = new Order

        {

            Description = "o1",

            Amount = 1,

            Price = 3.3

        };

        var order2 = new Order

        {

            Description = "o2",

            Amount = 5,

            Price = 8

        };

        var customers = new List<Customer>

        {

            new Customer

            {

                Name = "Terri Lee Duffy",

                CompanyName = "ABC",

                City = "Paris",

                Phone = "333-444444",

                Orders = new List<Order> { order1, order1, order2 }

            },

            new Customer

            {

                Name = "Alfred",

                CompanyName = "KLM",

                City = "London"

            },

            new Customer

            {

                Name = "Happy",

                CompanyName = "Test",

                City = "New York"

            },

            new Customer

            {

                Name = "Jon",

                CompanyName = "ZZZ",

                City = "Canada"

            },

            new Customer

            {

                Name = "C",

                CompanyName = "ZZZ",

                City = "Amsterdam"

            }

        };

        var adminRole = new Role

        {

            Name = "Admin"

        };

        var managerRole = new Role

        {

            Name = "Manager"

        };

        var users = new List<User>

        {

            new User { Name = "Jack", Roles = new List<Role> { managerRole } },

            new User { Name = "Mike", Roles = new List<Role> { managerRole, adminRole } }

        };

​

        using (var context = new EntityContext())

        {

            context.Customers.AddRange(customers);

            context.Users.AddRange(users);

            context.BulkSaveChanges();

        }

    }

    public class EntityContext : DbContext

    {

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

        {

        }

        public DbSet<User> Users { get; set; }

        public DbSet<Customer> Customers { get; set; }

        public DbSet<Location> Locations { 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 Location Location { get; set; }

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

    }

    public class Order

    {

        public int Id { get; set; }

        public string Description { get; set; }

        public int Amount { get; set; }

        public double Price { get; set; }

    }

    public class Location

    {

        public int LocationID { get; set; }

        public string Name { get; set; }

    }

    public class User

    {

        public int Id { get; set; }

        public string Name { get; set; }

        public ICollection<Role> Roles { get; set; }

    }

    public class Role

    {

        public int Id { get; set; }

        public string Name { get; set; }

    }

}