I have a query that is suppose to get vendors from an sql table, i have an arraylist that contains ID's and i do not want the query to return vendors with those ID's that are in the array list.
This is what i have but it is not working i get a message saying "Method 'Boolean Contains(System.Object)' has no supported translation to sql"
qVendors = From TempVendor In DBV.Vendors _
Where Not arrExcludeList.Contains(TempVendor.ListID)
arrExcludeList contains all the ids that i DON'T want to return.
If anybody can see what i am doing wrong please help.