Making this query in LINQ-SQL?

Question

I have Employees, Groups, and EmployeeGroupFilters.

An Employee has a GroupID with foreign key relationship.

An EmployeeGroupFilter has an Employee and Group ID. Each employee can filter which groups they do not want to see in the calendar.

Thus, if an EmployeeGroupFilter exists, that employee will not see that group.

I need a query that will return an IEnumerable 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:

public static IEnumerable<EmployeGroupFilter> GetAllByEmployee(
int employeeID)
{
    KezberPMDBDataContext db = new KezberPMDBDataContext();

    return from p in db.EmployeGroupFilters
           where p.EmployeID == employeeID
           select p;
}

I need something like:

public static IEnumerable<Group> GetAllVisibleEmployeeGroups(
int employeeID)
{
    KezberPMDBDataContext db = new KezberPMDBDataContext();

    return from p in db.Groups
           .......
           select p;
}

AD.Net · Accepted Answer · 2013-01-29 16:49:20Z

3

return from p in db.Groups
where !p.EmployeGroupFilters.Any(fil=>fil.EmployeeId == employeeID)
           select p;

answered Jan 29, 2013 at 16:49

AD.Net

13.4k2 gold badges30 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

Making this query in LINQ-SQL?

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