DynamicLinq build select with subquery

Question

DynamicLinq build select with subquery

dynamic-linq entity-framework linq

Question

I use System.Linq.Dynamic.Core to dynamically create choose. I want to include one more column (subquery). Can this be done?

I want the same results as this search:

var test = this.DbContext.Countries.Select(t => new
{
    t.Id,
    t.ISOCode,
    lookup = t.Translates.Where(t2 => t2.LangISOCode=="ENG").Select(t2 => t2.Title).FirstOrDefault()
}).ToArray();

I accomplish this:

this.DbContext.Countries.Select("new(Id,ISOCode)").ToDynamicArrayAsync()

however I'm unsure of how to add more subquery columns.

Makla

Related Questions

View more on Stack Overflow

Makla · Accepted Answer · 12/21/2017 12:52:46 PM

Accepted Answer

The remedy is:

await this.DbContext.Countries.Select("new(Id,ISOCode,Translates.Where(LangISOCode=\"SLV\").Select(Title).FirstOrDefault() as translates)").ToDynamicArrayAsync();

I combined the source tests' code to find the answer (select, where, firstordefault).

Makla

DynamicLinq build select with subquery

Question

Fastest Entity Framework Extensions

Accepted Answer

Related Questions

Fastest Entity Framework Extensions

Performance

Expression Evaluator