I want to be able to call a custom function called "recent_date" as
part of my HQL. Like this: [Date] >= recent_date()
I created a new dialect, inheriting from MsSql2000Dialect and
specified the dialect for my configuration.
public class NordicMsSql2000Dialect : MsSql2000Dialect
{
public NordicMsSql2000Dialect()
{
RegisterFunction(
"recent_date",
new SQLFunctionTemplate(
NHibernateUtil.Date,
"dateadd(day, -15, getdate())"
)
);
}
}
var configuration = Fluently.Configure()
.Database(
MsSqlConfiguration.MsSql2000
.ConnectionString(c => .... )
.Cache(c => c.UseQueryCache().ProviderClass<HashtableCacheProvider>
())
.Dialect<NordicMsSql2000Dialect>()
)
.Mappings(m => ....)
.BuildConfiguration();
When calling recent_date() I get the following error:
System.Data.SqlClient.SqlException: 'recent_date' is not a recognized
function name
I'm using it in a where statement for a HasMany-mapping like below.
HasMany(x => x.RecentValues)
.Access.CamelCaseField(Prefix.Underscore)
.Cascade.SaveUpdate()
.Where("Date >= recent_date()");
What am I missing here?
PS. I've also posted this question on Stackoverflow if you prefer to
answer it there. Thanks!
http://stackoverflow.com/questions/1845884/custom-sql-function-for-nhibernate-dialect
--
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/fluent-nhibernate?hl=en.
