Okay just found issue NH-2661. Have now set the driver class property to NHibernate.Driver.Sql2008ClientDriver and the problem is solved.
/* Email: [email protected] Twitter: @simonmfox Phone: +64 21 079 2900 */ On Tue, Jun 21, 2011 at 3:35 PM, Simon Fox <[email protected]> wrote: > Hi All > > I'm having an issue querying TimeSpan properties that have been mapped to > time columns using TimeAsTimeSpan with NH 3.2. > > I initially got the issue querying a type that defines a composite key and > so thought it was something to do with having a time field in a composite > key but I then tested against a plain TimeSpan/time property and got the > same issue. > > Its boils down to a SqlException with the message "*The data types > datetime and time are incompatible in the equal to operator.*" > > Quick bit of googling and I found > http://blogs.msdn.com/b/jdbcteam/archive/2010/04/08/using-time-and-date-data-types-part-1-what-time-is-it.aspx > which > seems to be relevant and suggests that the following connection property > must be set *"**sendTimeAsDateTime=false".* > * > * > So I'm just wondering what the best way around this is. > > Cheers > Simon > > > /* > Email: [email protected] > Twitter: @simonmfox > Phone: +64 21 079 2900 > */ > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
