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

    {

        Person magnus = new Person { Name = "Hedlund, Magnus" };

        Person terry = new Person { Name = "Adams, Terry" };

        Person charlotte = new Person { Name = "Weiss, Charlotte" };

​

        Pet barley = new Pet { Name = "Barley", Owner = terry };

        Pet boots = new Pet { Name = "Boots", Owner = terry };

        Pet whiskers = new Pet { Name = "Whiskers", Owner = charlotte };

        Pet daisy = new Pet { Name = "Daisy", Owner = magnus };

​

        var persons = new List<Person> { magnus, terry, charlotte };

        var pets = new List<Pet> { barley, boots, whiskers, daisy };

​

        // Stronly typed LINQ:

        var realQuery = persons

                .Join(

                    pets,

                    person => person,

                    pet => pet.Owner,

                    (person, pet) => new { OwnerName = person.Name, Pet = pet.Name });

        FiddleHelper.WriteTable(realQuery);

        // Dynamic LINQ

        var dynamicQuery = persons.AsQueryable()

                .Join(

                    pets,

                    "it",

                    "Owner",

                    "new(outer.Name as OwnerName, inner.Name as Pet)");

        foreach (dynamic result in dynamicQuery)

        {

            FiddleHelper.Dump(result);

        }

    }

​

    public class Person

    {

        public int Id { get; set; }

        public string Name { get; set; }

        public ICollection<Pet> Pets { get; set; }

    }

    public class Pet

    {

        public int Id { get; set; }

        public string Name { get; set; }

        public Person Owner { get; set; }

    }

}