CipherIS
asked on
C# Linq2SQL - Join IList and Table to Filter Data
I have a list and I need to filter it down more. I need to use data from a table to filter it more.
My list is Enrollments. I am able to get to Enroll.Emp.perID. I need to filter the table TermedEmp which has field perID also. Basically in SQL it would work like this.
Select *
From Enroll.Emp e
Where e.perID not in (
Select perID from TermedEmp
)
My list is Enrollments. I am able to get to Enroll.Emp.perID. I need to filter the table TermedEmp which has field perID also. Basically in SQL it would work like this.
Select *
From Enroll.Emp e
Where e.perID not in (
Select perID from TermedEmp
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.