01-08-02【Nhibernate (版本3.3.1.4000) 出入江湖】二级缓存:NHibernate自带的HashtableProvider
第一步骤:hibernate.cfg.xml文件补上如下配置:
<?xml version="1.0" encoding="utf-8"?> <!-- This template was written to work with NHibernate.Test. Copy the template to your NHibernate.Test project folder and rename it in hibernate.cfg.xml and change it for your own use before compile tests in VisualStudio. --> <!-- This is the System.Data.dll provider for SQL Server --> <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" > <session-factory name="NHibernate.Test123456"> <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property> <property name="connection.connection_string"> <!--用于测试自动生成数据库表(不自动生成数据库)--> <!--<property name="hbm2ddl.auto">update</property>--> Server=(local);initial catalog=NHibernateSampleAutoCreateTable;Integrated Security=SSPI <!--Server=(local);initial catalog=NHibernateSample;Integrated Security=SSPI--> </property> <property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property> <!--输出所有的SQL语句到控制台,一般开发打开这个--> <property name="show_sql">true</property> <!--整齐的SQL输出到控制台--> <property name="format_sql">true</property> <!--自动生成数据库表(不自动生成数据库)--> <property name="hbm2ddl.auto">update</property> <!--在数据表设计中如果采用了 bit 类型的字段,并且对应了业务类中类型为 bool 值,一定要如上设置下--> <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property> <!--=======加入Nhibernate自身的HashtabeCache的二级缓存配置=============================--> <!--1.配置二级缓存提供程序--> <property name="cache.provider_class">NHibernate.Cache.HashtableCacheProvider</property> <!--2.显式启用二级缓存--> <property name ="cache.use_second_level_cache">true</property> <!--4.启动查询缓存--> <property name="cache.use_query_cache">true</property> <!--实体类所在的程序集--> <mapping assembly="Model"/> <!--3.配置映射的二级缓存--> <class-cache class="Model.Customer,Model" usage="read-write"/> <!--<collection-cache collection ="集合名称" region="默认集合名称" usage="read-write"/>--> </session-factory> </hibernate-configuration>
实体类上也可以配二级缓存策略,如:
Customer.hbm.xml
<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="Model" assembly="Model" default-lazy="true"> <class name="Model.Customer, Model" table="Customer" discriminator-value="0" lazy="false"> <!--1.这个不是必须的,因为在nhibernate.cfg.xml文件中已经有了一个总配置 2.cache标签必须在id标签前面 --> <cache usage="read-write"/> <!--unsaved-value="0" 主键表中不需要定义,而是需要在子表中定义--> <id name="CustomerId" column="CustomerId" type="int" unsaved-value="0"> <generator class="native" /> <!-- unsaved-value used to be null and generator was increment in h2.0.3 --> </id> 。。。。。。。。。。。。。。。 <set name="Orders" table="Order" lazy="true" generic="true" inverse="false" cascade="all"> <!--二级缓存策略--> <cache usage="read-write"/> <key column="CustomerId" foreign-key="FK_CustomerOrders"/> <one-to-many class="Model.Order,Model"/> </set> </class> </hibernate-mapping>
测试1:
二级缓存与Get方法+Lazy设置的关系:
测试图解:


经测试,得出如下结论:
Get方法+Lazy配置+二级缓存测试结果:
Customer.hbm.xml的<Set name="Orders" Customer.hbm.xml的<Set name="Orders"
lazy="true"> lazy="false">
<cache usage="read-write"/> <cache usage="read-write"/>
Customer数据库中Order个数等于零 Get方法从二级缓存获取Customer Get方法从二级缓存获取Customer
Customer数据库中Order个数大于零 Get方法从二级缓存获取Customer Get方法从不从二级缓存获取Customer
------------------------更新二级缓存测试---------------------------------------------------------------
测试更新-1:
前置条件:
1.Customer没Orders
2.
<class name="Model.Customer, Model" table="Customer" discriminator-value="0" lazy="true"> <!--1.这个不是必须的,因为在nhibernate.cfg.xml文件中已经有了一个总配置 2.cache标签必须在id标签前面 --> <cache usage="read-write"/>
测试代码:

[TestMethod] public void TestSessionFactoryCacheUpdateCustomerHavingNotOrders() { CustomerService customerService = new CustomerService(); Customer customer = new Customer() { FirstName = "Test", LastName = "TestSessionFactoryCache", Age = 10 }; customerService.Add(customer); int customerId = customer.CustomerId; Console.WriteLine("第1次获取数据并且更新------------------------------:"); Customer customerGet1 = customerService.Get(customerId); Console.WriteLine("更新前:Id:{0}-->FirtstName:{1}" , customerGet1.CustomerId, customerGet1.FirstName); customerGet1.FirstName = "我是更新后的FirstName"; //修改FirstName customerService.Update(customerGet1); //保存更新得到数据库。 Console.WriteLine("更新后:Id:{0}-->FirtstName:{1}" , customerGet1.CustomerId, customerGet1.FirstName); Console.WriteLine("第2次获取数据==============================:"); Customer customerGet2 = customerService.Get(customerId); Console.WriteLine("Id:{0}-->FirtstName:{1}" , customerGet2.CustomerId, customerGet2.FirstName); Console.WriteLine("第3次获取数据==============================:"); Customer customerGet3 = customerService.Get(customerId); Console.WriteLine("Id:{0}-->FirtstName:{1}" , customerGet3.CustomerId, customerGet3.FirstName); }
测试结果:

NHibernate: INSERT INTO Customer (Version, Firstname, Lastname, Age) VALUES (@p0, @p1, @p2, @p3); select SCOPE_IDENTITY(); @p0 = 1 [Type: Int32 (0)], @p1 = 'Test' [Type: String (4000)], @p2 = 'TestSessionFactoryCache' [Type: String (4000)], @p3 = 10 [Type: Int32 (0)] 第1次获取数据并且更新------------------------------: NHibernate: SELECT customer0_.CustomerId as CustomerId0_0_, customer0_.Version as Version0_0_, customer0_.Firstname as Firstname0_0_, customer0_.Lastname as Lastname0_0_, customer0_.Age as Age0_0_ FROM Customer customer0_ WHERE customer0_.CustomerId=@p0; @p0 = 198 [Type: Int32 (0)] NHibernate: SELECT orders0_.CustomerId as CustomerId1_, orders0_.OrderId as OrderId1_, orders0_.OrderId as OrderId1_0_, orders0_.Version as Version1_0_, orders0_.OrderDate as OrderDate1_0_, orders0_.CustomerId as CustomerId1_0_ FROM [ Order] orders0_ WHERE orders0_.CustomerId=@p0; @p0 = 198 [Type: Int32 (0)] 更新前:Id:198-->FirtstName:Test NHibernate: UPDATE Customer SET Version = @p0, Firstname = @p1, Lastname = @p2, Age = @p3 WHERE CustomerId = @p4 AND Version = @p5; @p0 = 2 [Type: Int32 (0)], @p1 = '我是更新后的FirstName' [Type: String (4000)], @p2 = 'TestSessionFactoryCache' [Type: String (4000)], @p3 = 10 [Type: Int32 (0)], @p4 = 198 [Type: Int32 (0)], @p5 = 1 [Type: Int32 (0)] 更新后:Id:198-->FirtstName:我是更新后的FirstName 第2次获取数据==============================: Id:198-->FirtstName:我是更新后的FirstName 第3次获取数据==============================: Id:198-->FirtstName:我是更新后的FirstName
---------------------------------------------------
测试更新-2
前置条件:
1.Customer有Orders
2.
<set name="Orders" table="Order" lazy="false" generic="true" inverse="false" cascade="all"> <!--二级缓存策略--> <cache usage="read-write"/> <key column="CustomerId" foreign-key="FK_CustomerOrders"/> <one-to-many class="Model.Order,Model"/> </set>
测试代码和结果:表明2级缓存失效

[TestMethod] public void TestSessionFactoryCacheUpdateCustomerHavingOrders() { CustomerService customerService = new CustomerService(); Customer customer = new Customer() { FirstName = "Test", LastName = "TestSessionFactoryCache", Age = 10 }; Order order1 = new Order() { OrderDate = DateTime.Now, Customer = customer }; customer.Orders.Add(order1); customerService.Add(customer); int customerId = customer.CustomerId; Console.WriteLine("第1次获取数据并且更新------------------------------:"); Customer customerGet1 = customerService.Get(customerId); Console.WriteLine("更新前:Id:{0}-->FirtstName:{1}" , customerGet1.CustomerId, customerGet1.FirstName); customerGet1.FirstName = "我是更新后的FirstName"; //修改FirstName customerService.Update(customerGet1); //保存更新得到数据库。 Console.WriteLine("更新后:Id:{0}-->FirtstName:{1}" , customerGet1.CustomerId, customerGet1.FirstName); Console.WriteLine("第2次获取数据==============================:"); Customer customerGet2 = customerService.Get(customerId); Console.WriteLine("Id:{0}-->FirtstName:{1}" , customerGet2.CustomerId, customerGet2.FirstName); Console.WriteLine("第3次获取数据==============================:"); Customer customerGet3 = customerService.Get(customerId); Console.WriteLine("Id:{0}-->FirtstName:{1}" , customerGet3.CustomerId, customerGet3.FirstName); }

NHibernate: INSERT INTO Customer (Version, Firstname, Lastname, Age) VALUES (@p0, @p1, @p2, @p3); select SCOPE_IDENTITY(); @p0 = 1 [Type: Int32 (0)], @p1 = 'Test' [Type: String (4000)], @p2 = 'TestSessionFactoryCache' [Type: String (4000)], @p3 = 10 [Type: Int32 (0)] NHibernate: INSERT INTO [ Order] ( Version, OrderDate, CustomerId ) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY(); @p0 = 1 [Type: Int32 (0)], @p1 = 2014/5/29 23:15:57 [Type: DateTime (0)], @p2 = 199 [Type: Int32 (0)] 第1次获取数据并且更新------------------------------: NHibernate: SELECT customer0_.CustomerId as CustomerId0_0_, customer0_.Version as Version0_0_, customer0_.Firstname as Firstname0_0_, customer0_.Lastname as Lastname0_0_, customer0_.Age as Age0_0_ FROM Customer customer0_ WHERE customer0_.CustomerId=@p0; @p0 = 199 [Type: Int32 (0)] NHibernate: SELECT orders0_.CustomerId as CustomerId1_, orders0_.OrderId as OrderId1_, orders0_.OrderId as OrderId1_0_, orders0_.Version as Version1_0_, orders0_.OrderDate as OrderDate1_0_, orders0_.CustomerId as CustomerId1_0_ FROM [ Order] orders0_ WHERE orders0_.CustomerId=@p0; @p0 = 199 [Type: Int32 (0)] 更新前:Id:199-->FirtstName:Test NHibernate: UPDATE Customer SET Version = @p0, Firstname = @p1, Lastname = @p2, Age = @p3 WHERE CustomerId = @p4 AND Version = @p5; @p0 = 2 [Type: Int32 (0)], @p1 = '我是更新后的FirstName' [Type: String (4000)], @p2 = 'TestSessionFactoryCache' [Type: String (4000)], @p3 = 10 [Type: Int32 (0)], @p4 = 199 [Type: Int32 (0)], @p5 = 1 [Type: Int32 (0)] NHibernate: UPDATE [ Order] SET Version = @p0, OrderDate = @p1, CustomerId = @p2 WHERE OrderId = @p3 AND Version = @p4; @p0 = 2 [Type: Int32 (0)], @p1 = 2014/5/29 23:15:57 [Type: DateTime (0)], @p2 = 199 [Type: Int32 (0)], @p3 = 34 [Type: Int32 (0)], @p4 = 1 [Type: Int32 (0)] 更新后:Id:199-->FirtstName:我是更新后的FirstName 第2次获取数据==============================: NHibernate: SELECT order0_.OrderId as OrderId1_0_, order0_.Version as Version1_0_, order0_.OrderDate as OrderDate1_0_, order0_.CustomerId as CustomerId1_0_ FROM [ Order] order0_ WHERE order0_.OrderId=@p0; @p0 = 34 [Type: Int32 (0)] Id:199-->FirtstName:我是更新后的FirstName 第3次获取数据==============================: NHibernate: SELECT order0_.OrderId as OrderId1_0_, order0_.Version as Version1_0_, order0_.OrderDate as OrderDate1_0_, order0_.CustomerId as CustomerId1_0_ FROM [ Order] order0_ WHERE order0_.OrderId=@p0; @p0 = 34 [Type: Int32 (0)] Id:199-->FirtstName:我是更新后的FirstName
将该测试(测试更新-2)的前置条件2改为:
lazy="true" ,即修改后的配置如下:
<set name="Orders" table="Order" lazy="true" generic="true" inverse="false" cascade="all"> <!--二级缓存策略--> <cache usage="read-write"/> <key column="CustomerId" foreign-key="FK_CustomerOrders"/> <one-to-many class="Model.Order,Model"/> </set>
lazy="true" 时,2级缓存生效,测试结果如下所示:

NHibernate: INSERT INTO Customer (Version, Firstname, Lastname, Age) VALUES (@p0, @p1, @p2, @p3); select SCOPE_IDENTITY(); @p0 = 1 [Type: Int32 (0)], @p1 = 'Test' [Type: String (4000)], @p2 = 'TestSessionFactoryCache' [Type: String (4000)], @p3 = 10 [Type: Int32 (0)] NHibernate: INSERT INTO [ Order] ( Version, OrderDate, CustomerId ) VALUES (@p0, @p1, @p2); select SCOPE_IDENTITY(); @p0 = 1 [Type: Int32 (0)], @p1 = 2014/5/29 22:55:43 [Type: DateTime (0)], @p2 = 193 [Type: Int32 (0)] 第1次获取数据并且更新------------------------------: NHibernate: SELECT customer0_.CustomerId as CustomerId0_0_, customer0_.Version as Version0_0_, customer0_.Firstname as Firstname0_0_, customer0_.Lastname as Lastname0_0_, customer0_.Age as Age0_0_ FROM Customer customer0_ WHERE customer0_.CustomerId=@p0; @p0 = 193 [Type: Int32 (0)] 更新前:Id:193-->FirtstName:Test NHibernate: UPDATE Customer SET Version = @p0, Firstname = @p1, Lastname = @p2, Age = @p3 WHERE CustomerId = @p4 AND Version = @p5; @p0 = 2 [Type: Int32 (0)], @p1 = '我是更新后的FirstName' [Type: String (4000)], @p2 = 'TestSessionFactoryCache' [Type: String (4000)], @p3 = 10 [Type: Int32 (0)], @p4 = 193 [Type: Int32 (0)], @p5 = 1 [Type: Int32 (0)] 更新后:Id:193-->FirtstName:我是更新后的FirstName 第2次获取数据==============================: Id:193-->FirtstName:我是更新后的FirstName 第3次获取数据==============================: Id:193-->FirtstName:我是更新后的FirstName
经测试,得出如下结论:
Update方法+Get方法+Lazy配置+二级缓存测试结果:
Customer.hbm.xml的<Set name="Orders" Customer.hbm.xml的<Set name="Orders"
lazy="true"> lazy="false">
<cache usage="read-write"/> <cache usage="read-write"/>
----------------------------------------------------------------------------------------------------------------------------------------
Customer数据库中Order个数等于零 用 Update方法Customer后, 用 Update方法Customer后,
Get方法从二级缓存获取Customer Get方法从二级缓存获取Customer
-----------------------------------------------------------------------------------------------------------------------------------------
Customer数据库中Order个数大于零 用 Update方法Customer后 用 Update方法Customer后
Get方法从二级缓存获取Customer Get方法从不从二级缓存获取Customer
-----------------------------------------------------------------------------------------------------------------------------------------
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· PostgreSQL 和 SQL Server 在统计信息维护中的关键差异
· C++代码改造为UTF-8编码问题的总结
· 【.NET】调用本地 Deepseek 模型
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库