Nhibernate查询

 //NQL
            //返回表中的所有数据
            IList<User> allUsers = session.CreateQuery("from User").List<User>();

            //返回所有User的Id
            IList<int> allUserId = session.CreateQuery("select c.Id from User c").List<int>();

         

            //.Distinct用法.实例：获取不同User的Name。
            IList<string> dictName = session.CreateQuery("select  distinct c.Name from User c").List<string>();

            //where
            IList<User> getUserByFilter = session.CreateQuery("from User c where c.Name='dan'").List<User>();

            //order by

            IList<User> getUsersByOrderBy = session.CreateQuery("from User c order by c.Id asc").List<User>();

            //统计函数  
            IList<int> list = session.CreateQuery("select  avg(c.Id) ,sum(c.Id), count(c.Id)  from User c").List<int>();

            //group by

           // IList<User> getUsersByGroupBy = session.CreateQuery("select c.Name, count(c.Name) from User c group by c.Name").List<User>();