USING NHIBERNATE WITH MySQL

In previous USING NHIBERNATE WITH SQLITE, we connect SQLITE with ORM framework NHibernate. One of the biggest advantage of ORM is that most code need not be changed when switching different DBMS. In this article, MySQL is used for DBMS.

For the switching, hibernate.cfg.xml and default.build have to be updated.

1. hibernate.cfg.xml

Update the driver and connection string.

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
  <session-factory name="NHibernate.Test">
    <property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
    <property name="connection.connection_string">Server=localhost;Database=test;User ID=root;Password=</property>
    <property name="dialect">NHibernate.Dialect.MySQLDialect</property>
    <property name="query.substitutions">true=1;false=0</property>
    <property name="show_sql">true</property>
  </session-factory>
</hibernate-configuration>

2. default.xml

Update assembly dependencies.

<?xml version="1.0"?>
<project name="SQLite with NHibernate" default="run">
    <property name="debug" value="true" />
    <property name="outdir" value="bin" />
    <property name="libdir" value="../lib" />
    <property name="mysql_libdir" value="../../MySQL/lib/v4.0" />
    <target name="clean" description="remove all generated files">
        <delete dir="${outdir}" />
    </target>
    <target name="build" description="compiles the source code">
        <mkdir dir="${outdir}" />
        <csc debug="${debug}" output="${outdir}/NHExample.exe" target="exe">
            <references basedir="${libdir}">
                <include name="NHibernate.dll" />
            </references>
            <sources>
                <include name="Domain/Product.cs" />
                <include name="NHExample.cs" />
            </sources>
            <resources dynamicprefix="true" prefix="NHExample.Domain">
                <include name="Mappings/*.hbm.xml" />
            </resources>
        </csc>
        <copy todir="${outdir}">
            <fileset basedir="${libdir}">
              <include name="NHibernate.dll" />
              <include name="NHibernate.xml" />
              <include name="Iesi.Collections.dll" />
              <include name="Iesi.Collections.xml" />
            </fileset>
        </copy>
        <copy todir="${outdir}">
            <fileset basedir="etc">
              <include name="hibernate.cfg.xml" />
            </fileset>
        </copy>
        <copy todir="${outdir}">
            <fileset basedir="${mysql_libdir}">
                <include name="mysql.data.dll" />
                <include name="mysql.data.entity.dll" />
            </fileset>
        </copy>
    </target>
    <target name="run" depends="build">
        <exec program="${outdir}/NHExample.exe" workingdir="${outdir}"/>
    </target>
</project>

执行的输出结果：

Done. We have make the DBMS switching without coding and changing mappings.