Linq query in sql ce with Ado.net Entity Framework problem

i have simple linq query , var a=from b in myentity.tablea           b.fielda=="title"           select b; but error occured : "the ntext , image data types cannot used in where, having, group by, on, or in clauses, except when these data types used or null predicates" but fielda is  varchar(100)  not ntext type . my database sqlce 3.5sp1 . any advice appreciate . thanks.

i suppose query trying out looks similar below one:

          // generates paramterized query above query doesn't.

          string value = "title";

          var = from b in myentity.tablea

                     where b.fielda == value

                     select b;

 

if so, @ forum more details , workaround issue.

http://forums.microsoft.com/technet/showpost.aspx?postid=3746251&siteid=17

 

or if you are facing issues exact query given sample (which souldn't case), let know more details figure out root cause of issue.

 

thanks,

vamshi krishna, sql compact, msft.

SQL Server  >  SQL Server Compact