Replicating the SQL statement Select * From TableA Where Field1 In (Select Field 1 From Table B)
Did you ever want to constrain a list by values in another list using Linq? Kind of like the IN clause in a SQL Select Statement. i.e. Select * From TableA Where Field1 In (Select Field 1 From Table B)
While there is no IN clause in Linq there are a variety of ways I have seen others do this I have my own VB.Net solution to this problem that was in answer to someone's question on an MSDN VB Forum.