title: Problem using string.IsnullorEmpty in linq query
body: <p>I have a linq query in which i want to include those record which are not null or empty in database field but when i use string.isNullorEmpty it gives me error. How can i achieve this task my query is</p>
  
  <pre><code>from post in PostIdPostMeta1
  join pstmt in postrepository.GetAllPostMetas() on post.int_PostId equals pstmt.int_PostId
  where string.IsNullOrEmpty(pstmt.vcr_MetaValue) == false
  select post
  </code></pre>
  
  <p>If i change <strong>string.IsNullOrEmpty(pstmt.vcr_MetaValue) == false</strong> to <strong>pstmt.vcr_MetaValue != string.Empty</strong> it give me <strong>SQL Server does not handle comparison of NText, Text, Xml, or Image data types</strong> error</p>