[NHibernate]立即加载

 1         /// <summary>
 2         /// 采用立即加载的方式加载客户信息
 3         /// </summary>
 4         /// <param name="customerID"></param>
 5         /// <returns></returns>
 6         public Customer GetCustomerByImmediatelyLoad(Guid customerID)
 7         {
 8             //获得ISession实例
 9             //通过using的方式将session释放，为了保证是立即加载的数据，而不是延迟加载的
10             //还记得上篇文章中提到的在延迟加载中，在关闭session情况下，再读取数据的时候就会有一个异常信息
11             //忘记的可以再回到上一篇文章进行查看
12             using (ISession session = NHibernateHelper.GetSession())
13             {
14                 return session.Get<Customer>(customerID);
15             }
16         }

1     <!--一对多关系:一个客户可以有一个或者多个订单-->
2     <!--子实体负责维护关联关系-->
3     <set name="Orders" table="TB_Order" generic="true" inverse="true" cascade="all" lazy="false">
4       <key column="CustomerID" foreign-key="FK_TB_Order_TB_Customer"></key>
5       <one-to-many class="Wolfy.Shop.Domain.Entities.Order,Wolfy.Shop.Domain"/>
6     </set>

1 exec sp_executesql N'SELECT customer0_.CustomerID as CustomerID0_0_, customer0_.Version as Version0_0_, customer0_.CustomerName as Customer3_0_0_, customer0_.CustomerAddress as Customer4_0_0_ FROM TB_Customer customer0_ WHERE customer0_.CustomerID=@p0',N'@p0 uniqueidentifier',@p0='B0720295-9541-40B3-9994-610066224DB8'
2 
3 exec sp_executesql N'SELECT orders0_.CustomerID as CustomerID1_, orders0_.OrderID as OrderID1_, orders0_.OrderID as OrderID1_0_, orders0_.OrderDate as OrderDate1_0_, orders0_.CustomerID as CustomerID1_0_ FROM TB_Order orders0_ WHERE orders0_.CustomerID=@p0',N'@p0 uniqueidentifier',@p0='B0720295-9541-40B3-9994-610066224DB8'

 1         /// <summary>
 2         /// NHibernateUtil方式，立即加载客户信息及关联的数据
 3         /// </summary>
 4         /// <param name="customerID"></param>
 5         /// <returns></returns>
 6         public Customer GetCustomerByImmediatelyLoadNHibernateUtil(Guid customerID)
 7         {
 8             //获得ISession实例
 9             //通过using的方式将session释放，为了保证是立即加载的数据，而不是延迟加载的
10             //还记得上篇文章中提到的在延迟加载中，在关闭session情况下，再读取数据的时候就会有一个异常信息
11             //忘记的可以再回到上一篇文章进行查看
12             using (ISession session = NHibernateHelper.GetSession())
13             {
14                 Customer customer = session.Get<Customer>(customerID);
15                 //
16                 // 摘要: 
17                 //     Force initialization of a proxy or persistent collection.
18                 //
19                 NHibernate.NHibernateUtil.Initialize(customer.Orders);
20                 return customer;
21             }
22         }

 1        /// <summary>
 2         /// NHibernateUtil方式，立即加载订单与商品
 3         /// </summary>
 4         /// <param name="customerID"></param>
 5         /// <returns></returns>
 6         public Order GetOrderProductByImmediatelyLoadNHibernateUtil(Guid orderId)
 7         {
 8             using (var session = NHibernateHelper.GetSession())
 9             {
10                 var order = session.Get<Wolfy.Shop.Domain.Entities.Order>(orderId);
11                 //强制初始化customer
12                 NHibernate.NHibernateUtil.Initialize(order.Customer);
13                 //强制初始化Product
14                 NHibernate.NHibernateUtil.Initialize(order.Products);
15                 return order;
16             }
17         }

1 exec sp_executesql N'SELECT order0_.OrderID as OrderID1_0_, order0_.OrderDate as OrderDate1_0_, order0_.CustomerID as CustomerID1_0_ FROM TB_Order order0_ WHERE order0_.OrderID=@p0',N'@p0 uniqueidentifier',@p0='78A53F67-A293-48A1-BBE2-86FED77342FA'
2 
3 exec sp_executesql N'SELECT customer0_.CustomerID as CustomerID0_0_, customer0_.Version as Version0_0_, customer0_.CustomerName as Customer3_0_0_, customer0_.CustomerAddress as Customer4_0_0_ FROM TB_Customer customer0_ WHERE customer0_.CustomerID=@p0',N'@p0 uniqueidentifier',@p0='B0720295-9541-40B3-9994-610066224DB8'
4 
5 exec sp_executesql N'SELECT products0_.OrderID as OrderID1_, products0_.ProductID as ProductID1_, product1_.ProductID as ProductID3_0_, product1_.Name as Name3_0_, product1_.Price as Price3_0_ FROM TB_OrderProduct products0_ left outer join TB_Product product1_ on products0_.ProductID=product1_.ProductID WHERE products0_.OrderID=@p0',N'@p0 uniqueidentifier',@p0='78A53F67-A293-48A1-BBE2-86FED77342FA'

 1        /// <summary>
 2         /// HQL方式，立即加载订单与商品
 3         /// </summary>
 4         /// <param name="customerID"></param>
 5         /// <returns></returns>
 6         public Order GetOrderProductByImmediatelyLoadHQL(Guid orderId)
 7         {
 8             using (var session = NHibernateHelper.GetSession())
 9             {
10                 return session.CreateQuery("from Order o" +
11                     " left outer join fetch o.Products" +
12                     " inner join fetch o.Customer where o.OrderID=:orderId")
13                     .SetGuid("orderId", orderId)
14                     .UniqueResult<Order>();
15             }
16         }