NHibernate

mysql:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
  <!-- ISessionFactory实例 -->
  <session-factory>
    <property name="hbm2ddl.keywords">none</property>
    <!-- 属性 -->
    <!-- 设置connection provider，NHibernate将用之连接数据库 -->
    <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
    <!-- 设置所用driver，在此，我们为MySQL数据库选择MySqlDataDriver -->
    <property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
    <!-- 设置连接到数据库的connection string -->
    <property name="connection.connection_string">Server=127.0.0.1;Uid=root;Pwd=root;</property>
    <!-- 为特定数据库选择Dialect，这里选择使用MySQL5Dialect -->
    <property name="dialect">NHibernate.Dialect.MySQL5Dialect</property>
    <!-- 映射文件 -->
  </session-factory>
</hibernate-configuration>

sqlserver2005:

<?xml version="1.0" encoding="utf-8"?>
<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=127.0.0.1;Database=test;Uid=sa; Pwd=root;
    </property>
    <property name="adonet.batch_size">10</property>
    <property name="show_sql">true</property>
    <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
    <property name="command_timeout">10</property>
    <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
  </session-factory>
</hibernate-configuration>