I would like to join and query an in memory query and a fresh linq query. I will try and explain.
I have a query in memory (CurrentItem.ItemClauses).
I need to then join this to a fresh data base query (dbClause.LinksSpecificati
so i can do a contains statement (on clauseid). Here is my code at the moment but it is very slow.
For Each TempClause In CurrentItem.ItemClauses
Dim SpecID As Int32 = TempClause.SpecificationClauseID
Dim lsc = (From s In dbClause.LinksSpecificationClauses _
Where s.SpecificationClauseID = SpecID).SingleOrDefault
If lsc.ClauseID = ClauseID Then