public IEnumerable <Holiday> GetByMonth(int month, int year) { var startDate = new DateTime(year, month, 1); var endDate = DateSpan.EndOfMonth(startDate); return(Session .QueryOver <Holiday>() .Where(x => x.Date >= startDate) .And(x => x.Date <= endDate) .List()); }