NHibernate学习笔记(3)-实体反射到数据库

最新推荐文章于 2024-09-13 21:40:38 发布

weixin_30632089

最新推荐文章于 2024-09-13 21:40:38 发布

阅读量85

点赞数

文章标签：数据库 java 开发工具

原文链接：http://www.cnblogs.com/kimisme/p/5269213.html

版权

一、开发环境

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