Linq query, nested child objects in where, entity framework

Question

I have the following Entity Framework model which i am retrieving a number of marketing_campaign entities. A Marketing campaign can have multiple groups and each group can have multiple stores. enter image description here

What i need to be able to do is select all marketing campaigns for a particular StoreId. I know how to do the query for a single nested entity e.g. Groups.SelectMany(n => n.StoresInGroups).Where(s=>s.StoreId == 2); but not sure how to nest it deep enough to get the desired result.

Edit: Clearer picture

Alireza · Accepted Answer · 2013-09-23 19:40:30Z

1

var context = new context(); // init your context here
var query = 
    from sig in context.Store.Single(p=>p.StoreId = 2).StoresInGroup //filter out by particular toreId        
    from grp in sig.Group.Marketing_Groups
    from mc in grp.MarketingCampaign
    select mc;

answered Sep 23, 2013 at 19:40

Alireza

10.5k6 gold badges46 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Linq query, nested child objects in where, entity framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related