public List <EmployeeHolidaysInfo> GetEntities(long[] emplids, int year) { if (emplids == null || emplids.Length == 0) { return(null); } List <EmployeeHolidaysInfo> entities = GetTypedListFromIList( (IList)HibernateTemplate.Execute( delegate(ISession session) { //ICriteria criteria = session.CreateCriteria(typeof(EmployeeHolidaysInfo)); //return criteria.Add(Expression.Eq("Year", (short)year)) //.Add(Expression.In("EmployeeID", emplids)) //.List(); string hql = String.Format("select info from EmployeeHolidaysInfo info where info.EmployeeID IN {0} AND info.Year=(1)", QueryUtils.GetINString(emplids), year); return(session.CreateQuery(hql) .List()); } ) ); return(entities); }