CODEWITHSUNDEEP
c#asp.netnhibernateprovider
splatto
splatto

Reputation: 3227

NHibernate select most recent record that meets criteria

Last night I started working on an NHibernate provider. I'm creating a criteria that several records will match, however I only want to return the most recent record (the record with the largest Id). I thought UniqueResult() would do this it cannot be used if a list would be returned otherwise.

I could theoretically select the full list and then return the desired record, but I believe there is a better way.

Upvotes: 3

Views: 2485

Answers (2)

Joel
Joel

Reputation: 19368

Can you add an Order?

ICriteria cr = Session.CreateCriteria<MyType>();

cr.AddOrder(Order.Desc("Id"));

MyType justone = cr.UniqueResult();

Upvotes: 4

splatto
splatto

Reputation: 3227

Here is ultimately what was required. It was actually a combination of a couple of things I had earlier tried.

MyObject mo = (MyObject)_session.CreateCriteria(typeof(MyObject))
                .Add(Restrictions.Eq("Property", value))
                .AddOrder(Order.Desc("Id"))
                .SetMaxResults(1).UniqueResult();
            Log.Info(this, string.Format("Retrieving latest MyObject {0}.", mo.Name));
            return mo;

Upvotes: 0

Related Questions