Hi to everyone, reading documentation at http://www.hibernate.org/407.html I read that there is a function called AddSqlFunction to add function to a dialect without the need to subclass a Dialect but I cannot find in 1.2.0 beta3 release.

Moreover I tried to subclass a Dialect to introduce a new function, but even if I register the new function, when I use it into a query the parser ignore it and pass the function name unmodified into the query.

Thanks to everyone for any help.

Alk.

The function will be there in the CR1 release. It's possible that you can't add/override functions, I'll check this and update the page accordingly, thanks for the notice.

Thank you very much for the quick reply.

Is there any tutorial around that explain how to extend a dialect with subclassing? Ii tried to build a class like this

public class Sql2000Extended : NHibernate.Dialect.MsSql2000Dialect {

public Sql2000Extended() : base() {

this.RegisterFunction(
"ExBitwiseAnd",
new Sql2000BitwiseAndFunction("ExBitwiseAnd", NHibernate.NHibernateUtil.Int32));
}
}

With corresponding Sql2000BitwiseAndFunction that simulates a bitwise operation, then I changed App.config to load this new dialect but when I use ExBitwiseAnd function in HQL query I see from the profiler that the ExBitwiseAnd function is not translated.

Thanks a lot.

Alk.

You can't currently override functions in Dialect or through Configuration. I removed the relevant paragraph from the migration guide.

Ok, I understand, so in actual implementation there is not the possiblity to use custom functions. Thanks a lot for the explanation. :)

Alk.