Hibernate Community • View topic - DateTime .Net 2 SQL Server

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

DateTime .Net 2 SQL Server

Page 1 of 1

[ 6 posts ]

Previous topic | Next topic

Author

Message

dimikaka

Post subject: DateTime .Net 2 SQL Server

Posted: Tue Mar 21, 2006 4:03 pm

Newbie

Joined: Tue Mar 21, 2006 3:46 pm
Posts: 2

Hi,

what is the best way to use DateTime type?

The DateTime field of my class mappings:

Code:

The Property in the class:

Code:

public DateTime LastLogon 
{
   get { return m_dtLastLogon; }
   set { m_dtLastLogon = value; }
}

With the empty LastLogon I got an exception ;-(

Hibernate version: 1.0.2
.Net version: 2
Database: SQL Server

Thanks,
Dimi

Top

adelaid

Post subject:

Posted: Tue Mar 21, 2006 4:26 pm

Newbie

Joined: Tue Mar 21, 2006 4:18 pm
Posts: 11

Database field "LastLogon" is defined with IS NULL constraint?
Probably candidate for using NullableDateTime ...

Code:

<property name="LastLogon" type="Nullables.NHibernate.NullableDateTimeType, Nullables.NHibernate"/>

Code:

public DateTime? LastLogon
{
   get { return m_dtLastLogon; }
   set { m_dtLastLogon = value; }
}

Top

dimikaka

Post subject:

Posted: Wed Mar 22, 2006 7:50 am

Newbie

Joined: Tue Mar 21, 2006 3:46 pm
Posts: 2

I changed DateTime in DateTime? and it works fine.

Top

mdsrlz

Post subject:

Posted: Wed Mar 22, 2006 8:05 am

Senior

Joined: Fri Jan 13, 2006 2:50 pm
Posts: 123
Location: Blumenau / SC / Brasil

dimikaka wrote:

I changed DateTime in DateTime? and it works fine.

Yes, you can use DateTime? but just in your classes. Your hbm.xml continues the same.

Top

Mike_XP

Post subject:

Posted: Thu Apr 20, 2006 8:13 pm

Newbie

Joined: Thu Apr 20, 2006 7:06 pm
Posts: 1

mdsrlz wrote:

dimikaka wrote:

I changed DateTime in DateTime? and it works fine.

Yes, you can use DateTime? but just in your classes. Your hbm.xml continues the same.

Please can you give me a short hint: What is the meaning of a type with a following "?". How does C# interprete "DateTime?" ?

Thanks
Mike

Top

k-dub

Post subject:

Posted: Fri Apr 21, 2006 2:44 pm

Contributor

Joined: Thu May 12, 2005 8:45 am
Posts: 226

Nullable

Top

Page 1 of 1

[ 6 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum