mysql - NHibernate 数据库创建后如何将固定数据插入数据库？

Question

我想在数据库创建后将固定数据插入表(如城市、城镇、工作、部门等)。我想我需要一个 NHibernate 辅助类来做到这一点，但是怎么做呢？

public static ISessionFactory CreateSessionFactory()
{
    IPersistenceConfigurer dbConfigurer = MySQLConfiguration.Standard.ConnectionString(c => c.FromConnectionStringWithKey("test_nh"));

    var fConfig = Fluently.Configure()
        .Database(dbConfigurer)
        .Mappings(m => m.FluentMappings
            .AddFromAssemblyOf<Adres>()
            )
        .ExposeConfiguration(cfg =>
                                {
                                    SchemaExport config = new SchemaExport(cfg).Create(true, true);
// I think code will be here
// There is file which contains sql script to insert data
                                })
        .BuildSessionFactory();

    return fConfig;
}

Answer 1

创建数据库后，我不知道如何处理 session 。我现在想通了，解决方案是这样的:

public static ISessionFactory CreateSessionFactory()
{
    IPersistenceConfigurer dbConfigurer = MySQLConfiguration.Standard.ConnectionString(c => c.FromConnectionStringWithKey("test_nh"));

    var fConfig = Fluently.Configure()
        .Database(dbConfigurer)
        .Mappings(m => m.FluentMappings
            .AddFromAssemblyOf<Adres>()
            )
        .ExposeConfiguration(cfg =>
                                {
                                    SchemaExport config = new SchemaExport(cfg);
                                    config.Create(true, true);

                                    var ses1 = cfg.BuildSessionFactory().OpenSession();
                                    TextReader tr = new StreamReader(@"P:\cbo\App_Code\FixedSQL\Countries.sql");
                                    string sql = tr.ReadToEnd();
                                    var ulkeler= ses1.CreateSQLQuery(sql).List();
                                })
        .BuildSessionFactory();
    return fConfig;
}

PS:sql 文件大小对于 MySQL 很重要。如果您想扩展它，您应该将此行添加到 my.ini 文件中:

[mysqld]
max_allowed_packet = 32M