NHibernate query count

Question

I am new to NHibernate and I want to have a count of rows from database. Below is my code,

SearchTemplate template = new SearchTemplate();
            template.Criteria = DetachedCriteria.For(typeof(hotel));
            template.Criteria.Add(Restrictions.Lt("CheckOutDate", SelDate) || Restrictions.Eq("CheckOutDate", SelDate));
            template.Criteria.Add(Restrictions.Eq("Canceled", "False"));
    int count = template.Criteria.SetProjection(Projections.Count("ID"));

It gives me an error when I try to compile app that says "Cannot implicitly convert type 'NHibernate.Criterion.DetachedCriteria' to 'int'"

I want to have a count of rows of the table hotel..

Community · Accepted Answer · 2017-05-23 11:55:22Z

2

You want to use GetExecutableCriteria:

SearchTemplate template = new SearchTemplate();
        template.Criteria = DetachedCriteria.For(typeof(hotel));
        template.Criteria.Add(Restrictions.Lt("CheckOutDate", SelDate) || Restrictions.Eq("CheckOutDate", SelDate));
        template.Criteria.Add(Restrictions.Eq("Canceled", "False"));

var count = DoCount(template.Criteria, session /* your session */);

public long DoCount(DetachedCriteria criteria, ISession session)
{
     return Convert.ToInt64(criteria.GetExecutableCriteria(session)
                   .SetProjection(Projections.RowCountInt64())
                   .UniqueResult());
}

On a side note, you should take a look at using NHibernate.Linq:

var result = (from h in Session.Linq<Hotel>()
             where h.CheckOutDate <= SelDate
             where h.Canceled != true
             select h).Count();

More information here.

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Sep 24, 2010 at 21:19

rebelliard

9,6217 gold badges49 silver badges80 bronze badges

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

1 Comment

developer Over a year ago

How would I use it in my situation. How would I change the above code that I have posted so that it uses the function that you have provided?

Collectives™ on Stack Overflow

NHibernate query count

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related