Nullable DateTime Problem

sandipandeb · **Joined:** Mon Oct 17, 2005 1:58 am **Posts:** 27

I am trying to use the Nullable DateTime field from Nhibernate contrib in my DAL.For that i have added reference of Nullables.dll to my DAL assembly
But when i run a test application using the DAL i get the following exception

Additional information: could not interpret type: Nullables.NHibernate.NullableDateTimeType, Nullables.NHibernate

The following is the mapping info i have added in the hbm file

<property name="RemovalDate" column="REMOVAL_DATE" type="Nullables.NHibernate.NullableDateTimeType, Nullables.NHibernate" />

Can any body tell me why?

Thanks

michal · **Posted:** Tue Mar 21, 2006 4:53 am

You need also Nullables.NHibernate.dll assembly in the same directory where executing assembly. Reference to this assembly is not required.

sandipandeb · **Joined:** Mon Oct 17, 2005 1:58 am **Posts:** 27

Now After adding Nullables.NHibernate.dll in the Executing Assembly folder I am getting the following exception

An unhandled exception of type 'System.IO.FileLoadException' occurred in dal.dll

Additional information: The located assembly's manifest definition with name 'NHibernate' does not match the assembly reference.

What do you think could be the reason?

michal · **Posted:** Tue Mar 21, 2006 5:21 am

Probably Nullables.Nhibernate.dll -> Nullables.dll or NHibernate.dll version mismatch.
The only I can suggest - try using ildasm.exe tool from framework sdk on your Nullables.Nhibernate.dll to see what version of Nullables.dll and NHibernate.dll it references (lt is is stored in MANIFEST) and compare it with versions you are using (e.g. using windows explorer).

sandipandeb · **Joined:** Mon Oct 17, 2005 1:58 am **Posts:** 27

You were right.There was a version mismatch.So i corrected it.But now the first error has again crept in.The exception is

Additional information: could not interpret type: Nullables.NHibernate.NullableDateTimeType, Nullables.NHibernate

michal · **Posted:** Tue Mar 21, 2006 5:53 am

Sorry I have no futher ideas. Maybe you can look at these posts, they both describe simmilar problem:

http://forum.hibernate.org/viewtopic.php?t=951870
http://forum.hibernate.org/viewtopic.php?t=951619

mdsrlz · **Posted:** Tue Mar 21, 2006 8:19 am

Why don't you just use the Nullable of the .NET Framework?

I'm using... you should use DateTime? instead of DateTime, but just in you classes. Your hbm.xml still the same (DateTime).

If you know portuguese, I've written an article about it: http://www.linhadecodigo.com.br/artigos ... =949&pag=1

sandipandeb · **Joined:** Mon Oct 17, 2005 1:58 am **Posts:** 27

Are u suggesting that i use NullableDateTime data type of .NET Framework 2.0?

mdsrlz · **Posted:** Wed Mar 22, 2006 7:58 am

sandipandeb wrote:

Are u suggesting that i use NullableDateTime data type of .NET Framework 2.0?

Yes.