Nested parameters

[zspitz]

Given the following hierarchy:

public class Person {
    public string Name {get; set;}
    public Post[] Posts {get;set;}
}
public class Post {
    public string Text {get;set;}
    public string[] Tags {get;set;}
}

how can I write the equivalent of the following query:

var lst = new List<Person>();
var qry = lst.AsQueryable().Where(p => p.Posts.Any(p1 => p1.Text.Contains(p.Name)));

I've seen the use of outerIt to refer to the outer parameter, but the following code:

var selector = "Posts.Any(Text = outerIt.Name)";
var prm = Parameter(typeof(Person));
var parser = new ExpressionParser(new[] { prm }, selector, new object[] { }, ParsingConfig.Default);

fails with:

System.Linq.Dynamic.Core.Exceptions.ParseException: 'No property or field 'outerIt' exists in type 'Post''

An additional question: what happens if an additional level of parameter is required? e.g. the equivalent of:

var qry = lst.AsQueryable().Where(
    p => p.Posts.Any(
        p1 => p1.Tags.Any( 
            t => t.Contains(p.Name) || p1.C.ontains(p.Name)
        )
    )
);

[mrlife]

@StefH Just wondering, is referring to an outer predicate possible?

var test = context.Set<MyEntity1>()
    .Select(a => new MyItem { 
        Name = context.Set<MyEntity2>()
            .where("b => b.Prop == a.Prop")
            .FirstOrDefault()
            .Name
     });

Perhaps related to the original question, what is the it in this line?

[zspitz]

@mrlife What do you think of numbered its, starting from the outermost parameter? In other words, the equivalent of this:

var qry = lst.AsQueryable().Where(
    p => p.Posts.Any(
        p1 => p1.Tags.Any( 
            t => p.Name.Contains(t) || p1.Text.Contains(t)
        )
    )
);

might be written as this:

var qry = lst.AsQueryable.Where("Posts.Any(Tags.Any(it.Name.Contains(it2) || it1.Text.Contains(it2)");