public static void Init(TestContext context)
{
DropCreateDatabase();
Config =
MySQLConfiguration.Standard.ConnectionString(
ConfigurationManager.ConnectionStrings["RepoTestMySql"].ConnectionString);
}
public static void MigrateMySQLDb()
{
var configuration = new MySQLConfiguration();
configuration.TargetDatabase = new DbConnectionInfo(connectionMySQLStr, "MySql.Data.MySqlClient");
var migrator = new DbMigrator(configuration);
migrator.Update();
}
private MySQLConfiguration GetMysqlConfiguration(NhibernateSettings nhibernateSettings)
{
MySQLConfiguration config =
MySQLConfiguration.Standard
.ConnectionString(nhibernateSettings.ConnectionString)
.DefaultSchema(nhibernateSettings.DBSchema);
if (nhibernateSettings.ShowSQL)
{
config.ShowSql();
}
return(config);
}
private MySQLConfiguration GetMysqlConfiguration()
{
MySQLConfiguration config =
MySQLConfiguration.Standard
.ConnectionString(_connectionString)
.DefaultSchema(_nhibernateSchema);
if (_showSql)
{
config.ShowSql();
}
return(config);
}
private static IPersistenceConfigurer MySqlConfigureDatabase(NHConfigurationSection nhConfiguration)
{
MySQLConfiguration cfg = MySQLConfiguration.Standard
.ConnectionString(c => c.FromConnectionStringWithKey(nhConfiguration.ConnectionStringName))
.UseOuterJoin()
.DefaultSchema(nhConfiguration.DatabaseSchema);
#if DEBUG
cfg.ShowSql();
#endif
return(cfg);
}
private static void InitializeSession()
{
//Standard静态方法返回一个MySQLConfiguration对象实例，
//调用实体里的ConnectionString方法对它进行各项内容的配置,
//上述方法参数是action<MySQLConnectionBuilder>的委托,
//输入一个MySQLConnectionBuilder，并调用封装好的各个方法对builder赋值
//ConnectionString返回构造好的MySQLConfiguration。
MySQLConfiguration config = MySQLConfiguration.Standard.ConnectionString(
db => db.Server("localhost").Database("taidou")
.Username("root").Password("123456"));
//利用上面的数据库信息开始配置Nhibernate
//应用mappings进行映射，将当前类所在的程序集中的所有映射添加到配置映射配置中
//使用fluentConfiguration构造Isessionfactory
sessionFactory =
Fluently.Configure().Database(config).Mappings(x => x.FluentMappings.AddFromAssemblyOf <NHibernateHelper>())
.BuildSessionFactory();
}
private ISessionFactory getSessionFactory()
{
if (_sessionFactory == null)
{
MyAutoMappingConfiguration mappingCfg = new MyAutoMappingConfiguration();
MySQLConfiguration dataConfig = MySQLConfiguration.Standard
.ShowSql()
.ConnectionString(s => s.FromConnectionStringWithKey("conn"));
_sessionFactory = Fluently.Configure()
.Database(dataConfig)
.Mappings(
/*automampping can't work with override
* m => m.AutoMappings.Add(AutoMap.AssemblyOf<NModel.Product>(mappingCfg)
* .Conventions.Setup(c=>{
* c.Add<DefaultStringLengthConvention>();
* })
* .Override<NModel.Product>(map =>
* {
* map.Map(x => x.NTSCode).Unique();
* map.Map(x => x.State).CustomType<int>();
* })
* //.Override<NModel.Supplier>(map =>
* //{
* // map.Map(x => x.Code).Unique();
* //})
* )
* )*/
m => m.FluentMappings.AddFromAssemblyOf <NModel.Mapping.ProductMap>())
.ExposeConfiguration(BuildSchema)
.BuildSessionFactory();
}
return(_sessionFactory);
}
public MySQLPontoRepository(MySQLConfiguration configuration)
{
_mySqlConnection = new MySqlConnection(configuration.ConnectionString);
}
private static void InitSessionFactory()
{
MySQLConfiguration config = MySQLConfiguration.Standard.ConnectionString(c => c.Is(String.Format("Server={0};Database={1};User={2};Password={3};CharSet={4}", host, database, user, password, charSet)));
sessionFactory = Fluently.Configure().Database(config).Mappings(x => x.FluentMappings.AddFromAssemblyOf <DB>()).BuildSessionFactory();
}
private static void InitSessionFactory()
{
MySQLConfiguration mySQlConfig = MySQLConfiguration.Standard.ConnectionString(db => db.Server("127.0.0.1").Database("ardatabase").Username("root").Password("root"));
sessionFactory = Fluently.Configure().Database(mySQlConfig).Mappings(x => x.FluentMappings.AddFromAssemblyOf <NHibernateHelper>()).BuildSessionFactory();
}
// Use db as target
public MySqlFullContext(MySQLConfiguration config) : base(config)
{
config.IsolationLevel(IsolationLevel.ReadCommitted);
}
