Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 19, 2012 09:17 PM by krishnada25
Nov 19, 2012 08:19 PM|LINK
I am trying to do something like
Dim CDictionary As New Dictionary(Of String, String)
dim query = from queryItem in Dc1.TestTable
from cItem in Cdictionary where CItem.Key.contains(queryItem.ID)
I am getting an error
Local sequence cannot be used in LINQ to SQL implementations of query operators except the Contains operator.
How can I fix this??
Nov 19, 2012 09:17 PM|LINK
I was able to fix it by doing it like below.
Dim query = ( from queryItem on dc1.testTable)
If query is not nothing
Dim TestQuery = (from queryItem in query Select queryItem).tolist()
Dim FinalQuery = (from queryItem in Testquery join cItem in Cdictionary on citem.Key equals queryItem.ID.ToUpper)