一、开发环境
NHiberate版本:4.0.4
开发工具:VS2013
数据库:SQLServer2012
二、开发流程
1.编写领域类与映射文件
namespace Domain { public class Product { public virtual int Id { get; set; } public virtual string Name { get; set; } public virtual decimal UnitPrice { get; set; } } }
编写映射文件Product.hbm.xml:【嵌入的资源】
<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Domain" namespace="Domain"> <class name="Product" table="T_Product" lazy="true" > <id name="Id" column="Id" type="int" > <generator class="native" /> </id> <property name="Name" type="string"> <column name="Name" length="50"/> </property> <property name="UnitPrice" type="decimal"> <column name="UnitPrice" precision="14" scale="2"/> </property> </class> </hibernate-mapping>
2.配置NHiberate文件: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> <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property> <property name="connection.connection_string"> server=.;database=NHibernateDemo;uid=sa;pwd=love; </property> <property name="adonet.batch_size">10</property> <property name="show_sql">true</property> <property name="dialect">NHibernate.Dialect.MsSql2012Dialect</property> <property name="command_timeout">60</property> <property name="hbm2ddl.auto">update</property> <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property> <mapping assembly="Domain"/> </session-factory> </hibernate-configuration>
3.使用NHiberate工具生成对应的数据库结构
class Program { static void Main(string[] args) { var cfg = new NHibernate.Cfg.Configuration().Configure("Config/hibernate.cfg.xml"); //必须要写,否则无法反射 using (ISessionFactory sessionFactory = cfg.BuildSessionFactory()) { } Console.WriteLine("ok"); Console.ReadKey(); } }