CDS SDK Feature Request: Allow implicit joins in LINQ queries by resolving Navigation Properties

[dotfede]

This has been already reported at: https://github.com/MicrosoftDocs/powerapps-docs/issues/1054

That issue pretty much sums it up.

There's also a repro project here

The idea is being able to simplify this:

var accounts = 
    (from a in ctx.CreateQuery<Account>()
    join c in ctx.CreateQuery<Contact>() on a.PrimaryContactId.Id equals c.Id
    where c.FirstName.StartsWith("John")
    select a)
    .ToList();

into this:

var accounts =
    ctx.CreateQuery<Account>()
       .Where(x => x.PrimaryContact.FirstName.StartsWith("John"))
       .ToList();

[MattB-msft]

Thanks for the feedback.. will take a look at the feasibility of this.