Get current database server date using Castle ActiveRecord

Question

I found the solution, but I don't know how to translate those solution (in NHibernate) to ActiveRecord.

Answer 1

Instead of using a named queries (which I'm not even sure if Castle supports) you could create a native query which is essentially the same thing IMO.

    public static DateTime FindServerDateTime()
    {
        return Helper.GetSession()
            .CreateSQLQuery("select getdate()")
            .UniqueResult<DateTime>();
    }

Replace Helper.GetSession() with whatever function or property you use to fetch the Castle AR session.

Answer 2

Just for the record, Castle ActiveRecord does support HQL and SQL named queries (with [HqlNamedQuery] and [SqlNamedQuery] respectively), see this article. For this particular case, I agree with Mike, just use a simple SQL query.