基本操作增删改查

class TestUserManager
    {
        //得到所有的数据
        public IList<TestUser> GetAllUser()
        {
            using ( var session = NHibemateHelper.OpenSession())
            {
                using(var transaction = session.BeginTransaction())
                {
                    var userList = session.QueryOver<TestUser>();
                    transaction.Commit(); //提交
                    return userList.List();
                }
            }
        }

        //通过userName 得到一条数据
        public IList<TestUser> GetUserByUsername(string username)
        {
            using (var session = NHibemateHelper.OpenSession())
            {
                using (var transaction = session.BeginTransaction())
                {
                    var userList = session.QueryOver<TestUser>().Where(user=>user.Username == username);
                    transaction.Commit(); //提交
                    return userList.List();
                }
            }
        }

        //储存一条新的数据
        public void SaveUser(TestUser user)
        {
            using (var session = NHibemateHelper.OpenSession())
            {
                using (var transaction = session.BeginTransaction())
                {
                    session.Save(user);
                    transaction.Commit(); //提交
                }
            }
        }

        //根据id删除一条数据
        public void DeleteById(int id)
        {
            using (var session = NHibemateHelper.OpenSession())
            {
                using (var transaction = session.BeginTransaction())
                {
                    TestUser user = new TestUser();
                    user.Id = id;
                    session.Delete(user);
                    transaction.Commit(); //提交
                }
            }
        }

        //修改
        public void UpdateUser(TestUser tu)
        {
            using (var session = NHibemateHelper.OpenSession())
            {
                using (var transaction = session.BeginTransaction())
                {
                    session.Update(tu);
                    transaction.Commit(); //提交
                }
            }
        }