Where Condition on nvarchar or varbinary fields

Hi,

I am getting the below error when i use apply "Where" condition on nvarchar/varbinary datatypes in Sql Compact 3.5 using entity framework.

Error: The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except when these data types are used with the LIKE or IS NULL predicates

There are workarounds (hotfixes for Sql server compact 3.5) but please let me know if you have faced this issue in your application and resolved it.

Thanks in advance.

RajKumar | Answered# (13)
Reply For This Question
Answer(s) Posted
No Answer Found. Please post your answer!
Post Your Answer
   Please login to post your answer.
  Member Login
  Email Address  
  Password  
   Sign Up?  
  Privacy   Terms Of Use   Contact Us
© 2016 Developerin.Net. All rights reserved.
Trademarks and Article Images mentioned in this site may belongs to Microsoft and other respective trademark owners.
Articles, Tutorials and all other content offered here is for educational purpose only and its author copyrights.