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();
}