Using Oracle backend with NHibernate

mjama · **Posted:** Tue Mar 04, 2008 11:28 am

NHibernate version:1.2

I am using NHibernate 1.2, C#, ASP.NET 2.0, Oracle 9.
How do I pass sysdate/DateTime in NHibernate Criteria
My Criteria is as follows:
assignmentCriteria.Add(new LeExpression("START_DATE", startDate));
I am using C# DataTime
START_DATE Column is defined as oracle default Date (dd MMM yyyy in my Oracle database
I got some suggesion of using Oracle To_Date Function in the NHibernate Criteria but that did not work for me. It is as follows:
assignmentCriteria.Add(new LeExpression("START_DATE", "to_date('" + startDate + "','dd MMM yyyy')"));

Thanks fot any help

Please disregard this. I have solved my problem. Thank you.

FlukeFan · **Posted:** Tue Mar 04, 2008 1:19 pm

Hi,

I'm guessing you want something like:

Code:

assignmentCriteria.Add(Expression.Le("StartDate", startDate));

Can you post your mapping file to shed more light on the problem you're having? And also the exception you're getting?

Thanks,
Richard