Hey all, I have a table with two TIME columns on a SQL Server 2008 database. I'm running into problems when I try to query against them, and I think this is a bug in the Set() methods for the TimeAsTimeSpanType, TimeSpanType, and TimeType classes.
All of these methods add the value that's passed to the Set() method to the parameter array as a DateTime object, but at least on this MSDN page (http://msdn.microsoft.com/en-us/library/cc716729.aspx), it shows that the .NET type that's associated with DbType.Time should be TimeSpan, not DateTime. This is preventing me from running queries against these columns, because I always get an operand type clash: "The data types time and datetime are incompatible in the less than operator." (I'm doing a comparison between the parameter that I'm passing in and one of the TIME columns.) I'll likely try to work around this tomorrow by creating my own time type class with the correct type being placed into the command array. Can anyone else offer any insights into this? If not, I'll also raise it as an issue in the project's JIRA instance. - Neal -- 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.
