Linq to sql in Vb.net - How can I join a Table and a dictionary?? RSS

• • Reply
  

  krishnada25

  Member

  631 Points

  906 Posts

  Linq to sql in Vb.net - How can I join a Table and a dictionary??

  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??
  

  Please Don't mark the Question I posted as Answered until I do it.
  
  Thanks,
  Kris
• • Reply
  

  krishnada25

  Member

  631 Points

  906 Posts

  Re: Linq to sql in Vb.net - How can I join a Table and a dictionary??

  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)

  Please Don't mark the Question I posted as Answered until I do it.
  
  Thanks,
  Kris
  • Marked as answer by krishnada25 on Nov 19, 2012 09:17 PM