bring menus and active submenus C#

Question

I have to make a query through the menu I have to bring only the active submenus, see my code.

return context.Set<Menu>().Include("MenuGroups")
              .Where(x => x.Id == id && x.MenuGroups.Any(z => z.Active))
              .FirstOrDefault();

my return continues bringing my submenus with the status false

Answer 1

You have to install a package to add filter functionality to the include, install:

PM> Install-Package Z.EntityFramework.Plus.EF6

add the package reference:

using Z.EntityFramework.Plus;

then code:

return context.Set<Menu>()
              .IncludeFilter(x => x.MenuGroups.Where(z => z.Active == true))
              .Where(x => x.Id == id)
              .FirstOrDefault();

_References:

• Entityframework Plus (EF6)
• EF Query Includefilter | Entity Framework Include Related Entities using Where Filter