[Nhibernate]sqlite数据库基本使用

1 create table UserInfo
2 (
3 ID int primary key  not null,
4 UserName nvarchar(32),
5 Gender bit,
6 Age int,
7 Address nvarchar(128)
8 )

 1 <?xml version="1.0" encoding="utf-8"?>
 2 <!-- 
 3 This template was written to work with NHibernate.Test.
 4 Copy the template to your NHibernate.Test project folder and rename it in hibernate.cfg.xml and change it 
 5 for your own use before compile tests in VisualStudio.
 6 -->
 7 <hibernate-configuration  xmlns="urn:nhibernate-configuration-2.2" >
 8     <session-factory name="NHibernate.Test">
 9         <property name="connection.driver_class">NHibernate.Driver.SQLite20Driver</property>
10         <property name="connection.connection_string">
11             Data Source=nhibernate.db
12         </property>
13         <property name="dialect">NHibernate.Dialect.SQLiteDialect</property>
14     </session-factory>
15 </hibernate-configuration>

 1 <?xml version="1.0" encoding="utf-8"?>
 2 <hibernate-configuration  xmlns="urn:nhibernate-configuration-2.2" >
 3   <session-factory name="sqlite_session">
 4     <property name="connection.driver_class">NHibernate.Driver.SQLite20Driver</property>
 5     <property name="connection.connection_string">
 6       Data Source=C:\Users\Wolfy\Desktop\SQLiteSpy_1.9.8\Shop.db3
 7     </property>
 8     <property name="dialect">NHibernate.Dialect.SQLiteDialect</property>
 9     <mapping assembly="Wolfy.Domain"/>
10   </session-factory>
11 </hibernate-configuration>

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using System.Threading.Tasks;
 6 
 7 namespace Wolfy.Domain.Entity
 8 {
 9     /// <summary>
10     /// 用户持久化类
11     /// </summary>
12     public class UserInfo
13     {
14         /// <summary>
15         /// 用户标识
16         /// </summary>
17         public virtual int ID { set; get; }
18         /// <summary>
19         /// 用户姓名
20         /// </summary>
21         public virtual string UserName { set; get; }
22         /// <summary>
23         /// 性别
24         /// </summary>
25         public virtual bool Gender { set; get; }
26         /// <summary>
27         /// 年龄
28         /// </summary>
29         public virtual int Age { set; get; }
30         /// <summary>
31         /// 住址
32         /// </summary>
33         public virtual string Address { set; get; }
34     }
35 }

 1 <?xml version="1.0" encoding="utf-8" ?>
 2 <hibernate-mapping  xmlns="urn:nhibernate-mapping-2.2" assembly="Wolfy.Domain"  namespace="Wolfy.Domain.Entity">
 3   <class name="Wolfy.Domain.Entity.UserInfo,Wolfy.Domain" table="UserInfo">
 4     <!--主键 如果没有设置值则默认为0-->
 5     <id name="ID" type="Int32" unsaved-value="0">
 6       <column name="ID" sql-type="int" not-null="true" unique="true"/>
 7       <!--主键自增-->
 8       <generator class="increment"></generator>
 9     </id>
10     <property name="UserName" type="String">
11       <column name="UserName" sql-type="nvarchar"  not-null="false"/>
12     </property>
13     <property name="Gender" type="Boolean">
14       <column name="Gender" sql-type="bit" not-null="false"></column>
15     </property>
16     <property name="Age" type="Int32">
17       <column name="Age" sql-type="int" not-null="false"></column>
18     </property>
19     <property name="Address" type="String">
20       <column name="Address" sql-type="nvarchar"  not-null="false"/>
21     </property>
22   </class>
23 </hibernate-mapping>

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using System.Threading.Tasks;
 6 using NHibernate.Cfg;
 7 using NHibernate;
 8 using Wolfy.Domain.Entity;
 9 namespace Wolfy.Data
10 {
11     /// <summary>
12     /// 用户数据层操作
13     /// </summary>
14     public class UserInfoData
15     {
16         /// <summary>
17         /// 添加用户
18         /// </summary>
19         /// <param name="userInfo"></param>
20         /// <returns></returns>
21         public bool AddUserInfo(UserInfo userInfo)
22         {
23             ISession session = NHibernateHelper.GetOcextSession();
24             using (ITransaction trans = session.BeginTransaction())
25             {
26                 try
27                 {
28                     session.SaveOrUpdate(userInfo);
29                     session.Flush();
30                     trans.Commit();
31                     return true;
32                 }
33                 catch (Exception)
34                 {
35                     trans.Rollback();
36                     return false;
37                     throw;
38                 }
39             }
40         }
41     }
42 }

 1 using System;
 2 using Microsoft.VisualStudio.TestTools.UnitTesting;
 3 using Wolfy.Domain.Entity;
 4 using Wolfy.Data;
 5 
 6 namespace Wolfy.UnitTest
 7 {
 8     [TestClass]
 9     public class DataTest
10     {
11         private UserInfoData _userInfoData;
12         public DataTest()
13         {
14             _userInfoData = new UserInfoData();
15         }
16         [TestMethod]
17         public void AddUserInfoTest()
18         {
19             bool result = _userInfoData.AddUserInfo(new UserInfo()
20             {
21                 Address = "北京",
22                 Age = 25,
23                 Gender = true,               
24                 UserName = "wolfy"
25             });
26             Assert.IsTrue(result);
27         }
28     }
29 }