Making this query in LINQ-SQL?

[iCosmo]

I have \[code\]Employees\[/code\], \[code\]Groups\[/code\], and \[code\]EmployeeGroupFilters\[/code\].An \[code\]Employee\[/code\] has a \[code\]GroupID\[/code\] with foreign key relationship.An \[code\]EmployeeGroupFilter\[/code\] has an Employee and Group ID. Each employee can filter which groups they do not want to see in the calendar.Thus, if an \[code\]EmployeeGroupFilter\[/code\] exists, that employee will not see that group.I need a query that will return an \[code\]IEnumerable\[/code\] of Group which will be the groups that are VISIBLE to the employee.Ex: select all from Groups where group not in currentEmployee's Group filters.Right now I can get all the employees filters like this:\[code\]public static IEnumerable<EmployeGroupFilter> GetAllByEmployee(int employeeID){ KezberPMDBDataContext db = new KezberPMDBDataContext(); return from p in db.EmployeGroupFilters where p.EmployeID == employeeID select p;}\[/code\]I need something like:\[code\]public static IEnumerable<Group> GetAllVisibleEmployeeGroups(int employeeID){ KezberPMDBDataContext db = new KezberPMDBDataContext(); return from p in db.Groups ....... select p;}\[/code\]