title: Linq to sql equivalent query to sql server query
body: <p>I'm running the following LINQ to sql query but it returns no results..
  But when I run it [equivalent] in sql server it returns data !!</p>
  
  <pre><code> select * from [LocalizedProperty]
   where LanguageId = 3
   and LocaleValue like '%cards%'
   and (LocaleKey = 'Name' or LocaleKey = 'Description')
  </code></pre>
  
  <p>and linq query </p>
  
  <pre><code>Dim suggesstions As IEnumerable(Of LocalizedProperty) = _
                     (From sugg In result
                      Where sugg.LanguageId = 3 _
                      AndAlso sugg.LocaleValue.Contains(catalogRetrieveInfo.search_term) _
                      AndAlso (sugg.LocaleKey = "Name" OrElse sugg.LocaleKey = "Description") Select sugg)
  </code></pre>
  
  <p>Is this correct?</p>