Filter in child list LINQ Entity Framework

Question

Filter in child list LINQ Entity Framework

c# entity-framework-core

Question

I have list function contain list language in side

I want to filter that list Language with condition CulNo = "en".

Here is my code:

var functionLang = 
    functionVm.Where(x => x.Language.Any(y => y.LanguageCountry.CulNo == cul));

But it still returns all languages. How can I filter with list function have list language with my condition?

Thien Vu

View more on Stack Overflow

Eldho · Accepted Answer · 7/30/2018 6:22:52 AM

Popular Answer

You could try anonymous projection to filter

var langs = language
           .Select(g=> new 
           {
             g =  g.Language.where(y => y.LanguageCountry.CulNo == cul)
           }).ToList();

Filter child entities reference

Eldho

Filter in child list LINQ Entity Framework

Question

Fastest Entity Framework Extensions

Popular Answer

Performance

Expression Evaluator

Related