Saturday, 15 January 2011

Filtering Inner Collection in Entity Framework -


I have a team and each team holds a collection of product collection and product holding branches, each of the above mentioned units says that Field is called: Inactive I want to retrieve the team, products, branches that are only active (IACT = true).

  System.Data.Entity.Infrastructure.DbQuery & lt Team & gt; Query = dbContext.Teams.AsNoTracking (); Query = query.Include ("product"); Query = query Include ("Products."); // filtering active teams- queryMod = queryMod.Where (b => BISactive == active value); // Active product clearing filter mode = query mode. (B => B. Products where (C => CIsactive == active.value) All (D = & gt; D.I.Active == active .value)); // filter the active branches querymode = query mode Where (B => B. Products. All (C = & gt; C branches. All (D = & gt; D.I.Active == Active value) & amp; Iactive == Active Value);  

But it seems that it is not working as expected, what is the correct type of use of this statement to filter the inner groups, appreciate any direction or help She goes.

Thanks


No comments:

Post a Comment