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