How to get date with using Nhibernate from sql server!

Nicholas · **Joined:** Sun Dec 31, 2006 2:40 am **Posts:** 4

as the title!
Thanks![/b]

rhwilburn · **Posted:** Mon Jan 01, 2007 9:03 pm

http://www.hibernate.org/178.html This article has a bit of java code on how to do what u want.

from memory this is how it is done in .net (sort of in pseudo). The class is shown below:

Code:

class CLASSNAMEHERE
{

   public DateTime theDate
   {
       get { return System.datetime.Now(); }
   }

}

The mapping is nothing special, you do not need to declare a mapping type.

If this doesn't help there is a really good NHibernate example available at this link: http://www.benday.com/temp/nhibsampleVS2005.zip

merge_s.rottem · **Joined:** Tue Aug 23, 2005 5:52 am **Posts:** 335

The problem with this approach is that the datetime value is not from the SQL server but from the server where NHibernate is running.

I'm looking for a solution for this too.

Symon.

Nicholas · **Joined:** Sun Dec 31, 2006 2:40 am **Posts:** 4

Maybe I did not describe it clearly.
"select getdate()" how to do it with NHibernate!

Nicholas · **Joined:** Sun Dec 31, 2006 2:40 am **Posts:** 4

Maybe I did not describe it clearly.
"select getdate()" how to do it with NHibernate!

Nicholas · **Joined:** Sun Dec 31, 2006 2:40 am **Posts:** 4

Maybe I did not describe it clearly.
"select getdate()" how to do it with NHibernate!