public static DbMigrationProvider GetProvider(DbSetting dbSetting)
{
DbMigrationProvider provider = null;
//ISqlConverter Factory
switch (dbSetting.ProviderName)
{
case DbConnectionSchema.Provider_SqlClient:
provider = new SqlServerMigrationProvider();
break;
case DbConnectionSchema.Provider_SqlCe:
provider = new SqlServerCeMigrationProvider();
break;
//Patrickliu增加的代码块
case DbConnectionSchema.Provider_MySql:
provider = new MySqlMigrationProvider();
break;
//case "System.Data.Odbc":
// return new ODBCProvider();
default:
if (DbConnectionSchema.IsOracleProvider(dbSetting))
{
provider = new OracleMigrationProvider();
break;
}
throw new NotSupportedException("This type of database is not supportted now:" + dbSetting.ProviderName);
}
provider.DbSetting = dbSetting;
return(provider);
}
public static DbMigrationProvider GetProvider(DbSetting dbSetting)
{
DbMigrationProvider provider = null;
switch (dbSetting.ProviderName)
{
case DbConnectionSchema.Provider_SqlClient:
provider = new SqlServerMigrationProvider();
break;
case DbConnectionSchema.Provider_SqlCe:
provider = new SqlServerCeMigrationProvider();
break;
case DbConnectionSchema.Provider_MySql:
provider = new MySqlMigrationProvider();
break;
case DbConnectionSchema.Provider_SQLite:
provider = new SQLiteMigrationProvider();
break;
default:
if (DbConnectionSchema.IsOracleProvider(dbSetting))
{
provider = new OracleMigrationProvider();
break;
}
throw new NotSupportedException("This type of database is not supportted now:" + dbSetting.ProviderName);
}
provider.DbSetting = dbSetting;
return(provider);
}
/// <summary>
/// Initializes a new instance of the <see cref="DbMigrationContext"/> class.
/// </summary>
/// <param name="dbSetting">The database setting.</param>
/// <exception cref="System.ArgumentNullException">dbSetting</exception>
public DbMigrationContext(DbSetting dbSetting)
{
if (dbSetting == null)
{
throw new ArgumentNullException("dbSetting");
}
this.DbSetting = dbSetting;
this.RunDataLossOperation = DataLossOperation.None;
this._dbProvider = DbMigrationProviderFactory.GetProvider(dbSetting);
this._runGenerator = this._dbProvider.CreateRunGenerator();
this.DatabaseMetaReader = this._dbProvider.CreateSchemaReader();
}
public DbMigrationContext(DbSetting dbSetting)
{
if (dbSetting == null) throw new ArgumentNullException("dbSetting");
this.DbSetting = dbSetting;
this.RunDataLossOperation = DataLossOperation.None;
this._dbProvider = DbMigrationProviderFactory.GetProvider(dbSetting);
this._runGenerator = this._dbProvider.CreateRunGenerator();
this.DatabaseMetaReader = this._dbProvider.CreateSchemaReader();
}
