Hello everybody, I'm using Nhibernate with SQL Server and SQL Server CE 4.0. For a particular query, that works fine in SQL Server, I'm getting an exception when performed agains SQL CE.
This is the message I get: *"The function is not recognized by SQL Server Compact. [ Name of function = date,Data type (if known) = ]"* This is the query that NH is trying to perform (I'm using LinqToNh): select ... from "Evento" evento0_ inner join "GenericScheduleObject" evento0_1_ on evento0_.GenericScheduleObject_id=evento0_1_.Id where *date*(evento0_1_.Data)>=@p0 The problem is in the where clause.. How can I workaround this? Thanks in advance, Martino
