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.
