Using built-In SQL functions in NHIbernate Formula

Question

I am trying to map a NHibernate formula for a nullable datetime field that would use GetDate() if the column value is null.

The mapping I use is:

Map(x => x.VirtualStartDate).Formula("ISNULL(StartDate, GETDATE ())");

in Fluent NHibernate, which translates to hbm like this:

<property name="VirtualStartDate" formula="ISNULL(StartDate, GETDATE ())" type="System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

When I try to query the database NHibernate tries to map the built-in GetDate() function to a column in the table:

ISNULL(workitem0_.StartDate, workitem0_.GETDATE()) as formula0_

Which of course doesn't work and returns an SQL error. Is there any way to instruct NHIbernate that this is a built-in SQL function and he should leave it be?

Variant · Accepted Answer · 2011-02-07 10:47:23Z

1

Just solved it myself, apparently it works if the sql function is written is a lower case form.

answered Feb 7, 2011 at 10:47

Variant

17.4k4 gold badges44 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using built-In SQL functions in NHIbernate Formula

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related