/// <summary>
/// 根据指定的provider 和 connectionString 创建对应的链接数据库，不从本地配置文件中创建.
/// </summary>
/// <param name="provider"></param>
/// <param name="connectionString"></param>
/// <returns></returns>
public static Database CreateDatabase(string provider, string connectionString)
{
if (string.IsNullOrEmpty(provider))
{
throw new MB.Util.APPException("创建Database 时 provider 不能为空,请检查", Util.APPMessageType.SysErrInfo);
}
if (string.IsNullOrEmpty(connectionString))
{
throw new MB.Util.APPException("创建Database 时 connectionString 不能为空,请检查", Util.APPMessageType.SysErrInfo);
}
try {
var databaseSettings = new Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings();
var connStringSection = new System.Configuration.ConnectionStringsSection();
var dictDataSource = new Microsoft.Practices.EnterpriseLibrary.Common.Configuration.DictionaryConfigurationSource();
//针对SqLite provider 的特殊配置
var dbProvider = new Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DbProviderMapping("System.Data.SQLite", "EntLibContrib.Data.SQLite.SQLiteDatabase, EntLibContrib.Data.SqLite");
connStringSection.ConnectionStrings.Add(new System.Configuration.ConnectionStringSettings(DEFAULT_DB_NAME, connectionString, provider));
databaseSettings.ProviderMappings.Add(dbProvider);
databaseSettings.DefaultDatabase = DEFAULT_DB_NAME;
dictDataSource.Add(Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings.SectionName, databaseSettings);
dictDataSource.Add("connectionStrings", connStringSection);
var dbFactory = new DatabaseProviderFactory(dictDataSource);
var database = dbFactory.Create(DEFAULT_DB_NAME);
return(database);
}
catch (Exception ex) {
throw new MB.Util.APPException(string.Format("创建数据库连接出错,请检查Provider {0}, ConnectionString {1} 配置是否正确:" + ex.Message, provider, connectionString), APPMessageType.SysErrInfo);
}
}
public string getDefaultConnStr()
{
Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings defultSec = (Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings)config.GetSection("dataConfiguration");
return(defultSec.DefaultDatabase);
}
public bool setDefaultConnStr(string connKey)
{
bool bRet = false;
try
{
Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings defultSec = (Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings)config.GetSection("dataConfiguration");
defultSec.DefaultDatabase = connKey;
save();
bRet = true;
}
catch (System.Exception ex)
{
bRet = false;
}
return(bRet);
}
