nhibernate 配置mysql

Install-Package NHibernate
Install-Package MySql.Data

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration  xmlns="urn:nhibernate-configuration-2.2">
  <session-factory>
    <!-- 数据库连接设置 -->
    <property name="connection.provider">MySql.Data.MySqlClient</property>
    <property name="connection.driver_class">MySql.Data.MySqlClient.MySqlDriver</property>
    <property name="connection.connection_string">
      Data Source=localhost;Database=mydatabase;User Id=myuser;Password=mypassword;
    </property>

    <!-- 其他配置 -->
    <property name="dialect">NHibernate.Dialect.MySQLDialect</property>
    <property name="show_sql">true</property>
    <property name="format_sql">true</property>
    <property name="use_outer_join">false</property>
    <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>

    <!-- 映射文件 -->
    <mapping assembly="MyApp.Models" />
  </session-factory>
</hibernate-configuration>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="MyApp.Models" namespace="MyApp.Models">
  <class name="User" table="users">
    <id name="Id" column="id">
      <generator class="native" />
    </id>
    <property name="Username" column="username" />
    <property name="Email" column="email" />
  </class>
</hibernate-mapping>

using System;
using NHibernate;
using MyApp.Models;

class Program
{
    static void Main(string[] args)
    {
        // 配置 NHibernate
        var configuration = new Configuration().Configure();
        var sessionFactory = configuration.BuildSessionFactory();

        // 创建会话
        using (var session = sessionFactory.OpenSession())
        {
            // 开始事务
            using (var transaction = session.BeginTransaction())
            {
                try
                {
                    // 创建并保存用户
                    var user = new User { Username = "john", Email = "john@example.com" };
                    session.Save(user);

                    // 提交事务
                    transaction.Commit();
                }
                catch (Exception ex)
                {
                    // 回滚事务
                    transaction.Rollback();
                    Console.WriteLine("Error: " + ex.Message);
                }
            }
        }

        // 关闭会话工厂
        sessionFactory.Close();
    }
}