i am trying to select categories that ServiceType inside them contain services that have specific property
var categoryList = await _CategoryRepository.GetAll()
.Include(C => C.ServiceType)
.Include(C => C.ServiceType.Select(T => T.Services.Where(S => S.Employees.Any(E => E.UserId == userId))))
.ToListAsync();
i get the following error he Include path expression must refer to a navigation property defined on the type. Use dotted paths for reference navigation properties and the Select operator for collection navigation properties.
so how can i use use where inside include ?
