Entity Framework Linq include with where clause

Question

I have Audience Object and SocialAudience object. Audience can have one or many SocialAudience and other objects.

I want to get Audiences with there SocialAudiences that have IsDeleted column = 0.

 var audience = await db.Audiences.Include(A => A.AudienceUsersSources)
                                             .Include("AudienceUsersSources.AudienceUsersSourceDetails")
                                             .Include("SocialAudiences.AdAccount")
                                             .Where(A => A.CustomerCode == CustomerCode
                                                         && A.IsDeleted == 0
                                                         ).OrderByDescending(A => A.ID).ToListAsync();

the result of this code is audiences with socialAudiences that have IsDeleted = 0 and = 1.

Your question is slightly unclear. Can you post the Audience and SocialAudience classes? — johnnyRose, Sep 26 '17 at 16:46
you need audiences IsDeleted = 0 or SocialAudiences IsDeleted = 0? — who-aditya-nawandar, Sep 26 '17 at 17:17
@adityawho i need audience IsDeleted = 0 and SocialAudience IsDeleted = 0 — Zied CHAARI, Sep 26 '17 at 17:22
you could probably try something like this (https://stackoverflow.com/a/2670119/2110393) — who-aditya-nawandar, Sep 26 '17 at 17:29
Use the include part for the SocialAudiences at the end. Like how its done in the answer marked in the link. — who-aditya-nawandar, Sep 26 '17 at 17:39

score 1 · Answer 1 · answered Sep 26 '17 at 19:19

Since SocialAudiences is one to many you need to specify if you want it where Audience.IsDeleted == 0 and all of the SocialAudiences.IsDeleted == 0 or if just 1 has IsDeleted == 0. For the latter, try:

var audience = await db.Audiences
                       .Include(a => a.AudienceUsersSources.AudienceUsersSourceDetails)
                       .Include(a => a.SocialAudiences.AdAccount)
                       .Where(a => a.CustomerCode == CustomerCode &&
                                   a.IsDeleted == 0 &&
                                   a.SocialAudiences.Any(sa => sa.IsDeleted == 0))
                       .OrderByDescending(A => A.ID)
                       .ToListAsync();

If you require all the children to have IsDeleted == 0, then use All() instead of Any().

Entity Framework Linq include with where clause

1 Answers1