On Wed, Mar 25, 2009 at 1:46 PM, Roger Kratz <[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
-~----------~----~----~----~------~----~------~--~---

Reply via email to