public void Test_003_SearchByLinq() { ISession session = NHibernateHelper.GetCurrentSession(); var linqQuery = (from itemParamVO in session.Query <ItemParamVO>() //where itemParamVO.Name == "bbb" orderby itemParamVO.ItemParamId ascending select itemParamVO) .Skip(10).Take(2); //跳過前10項後取其他的前2項 var itemParamList = linqQuery.ToList(); //linqQuery.OfType<ItemParamVO>().ToList(); if (itemParamList != null && itemParamList.Count > 0) { foreach (ItemParamVO itemParamVO in itemParamList) { Console.Out.WriteLine("itemParamVO.Id = " + itemParamVO.ItemParamId); } } NHibernateHelper.CloseSession(); NHibernateHelper.CloseSessionFactory(); }
protected void Application_End() { NHibernateHelper.CloseSessionFactory(); container.Dispose(); }