Join with dependent subquery?

[zzzprojects]

Join with dependent subquery?

[StefH]

If possible, rebuild your question into a unit-test which can be included in the tests.

[AndrewZenith]

That would be difficult as I don't know how to do it. I'll try again though, this is perhaps a simpler example linq query (that works) that I want to do, but can it be done using the join extension using the string parameters?

IQueryable a = from zz in dyn2
join yy in dyn on dyn.Where(xx => xx.JobID == zz.JobID && xx.EventID == "EVENT2").Max(xy => xy.SQL_RFA) equals yy.SQL_RFA
select new { zz, yy };

[AndrewZenith]

I've downloaded your source and managed to write an example in the code similar to your join test. Here it is:

using System.Collections.Generic;
using System.Linq.Dynamic.Core.ConsoleTestApp.net452.Entities;

namespace System.Linq.Dynamic.Core.ConsoleTestApp.net452
{
    class Program
    {
        static void Main(string[] args)
        {
            Person magnus = new Person() { id=1, name = "a" };
            Person terry = new Person { id=2, name = "b" };

            Pet barley = new Pet { id = 1, name = "1p1", personid = 1 };
            Pet boots = new Pet { id = 2, name = "1p2", personid = 1  };
            Pet whiskers = new Pet { id = 3, name = "2p1", personid = 2 };


            var people = new List<Person> { magnus, terry };
            var pets = new List<Pet> { barley, boots, whiskers };

            //Act
            var realQuery = people.AsQueryable().Join(
                pets,
                person => 
                pets.Where(x => x.personid == person.id).Max(x => x.id),
                pet => pet.id,
                (person, pet) => new { OwnerName = person.name, Pet = pet.name });

            var realResult = realQuery.ToArray();

            var dynamicQuery = people.AsQueryable().Join(
               pets,
               "???",
               "id",
               "new(outer.name as OwnerName, inner.name as Pet)");

            var dynamicResult = dynamicQuery.ToDynamicArray<DynamicClass>();

        }
    }

    internal class Pet
    {
        public int id { get; set; }
        public int personid { get; set; }
        public string name { get; set; }
    }

    internal class Person
    {
        public int id { get; set; }
        public string name { get; set; }

    }
}

[StefH]

It's not possible to use external sub-query in a dynamic query.