Ok. Thanks. (However - I would personally feel more comfortable having the old way how a timestamp was mapped as the default one. The new "duration"/"moment of day" feels more like an explicit thing to map)
________________________________ Från: [email protected] [[email protected]] för Dario Quintana [[email protected]] Skickat: den 25 mars 2009 19:37 Till: [email protected] Ämne: [nhusers] Re: TimeSpan >24h or <0h On Wed, Mar 25, 2009 at 1:46 PM, Roger Kratz <[email protected]<mailto:[email protected]>> wrote: I’ve uploaded a patch to the JIRA which makes my tests pass. Roger, The patch partially applied r4154. A brief summary of what NH is supporting right now about this matter to manage duration: 1- The "TimeSpan" in the mapping, means: an hour from 00.00.00 to 23.59.59. Is mapped directly to a DbType.Time. Actually this it's not duration, it's a moment of the day, could not be negative or +24hs. In SqlServer2005 means a DateTime. We use the BaseDate to deal with the Date part in the RDBMS. In SqlServer2008 means a Time. 2- The "TimeSpanInt64" in the mapping means a duration of something, and the range is the same of Int64. Could be < 0h, > 24h. In SqlServer2005/2008 means a BigInt. 3- If you want to use "time" NHibernate type, then you've to use System.DateTime in your C# code. But it's messy to deal with a DateTime to manage a duration. I hope this clarify the situation. -- Dario Quintana http://darioquintana.com.ar --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
