110,534
社区成员
发帖
与我相关
我的任务
分享
public LocalEntities()
: base(Functions.GetConnectionString_Remote())
{
}
static public string GetConnectionString_Remote(bool isOnlySqlString = false)
{
return GetOracleConnectionString("Remote", isOnlySqlString);
}
static string GetOracleConnectionString(string name, bool isOnlyOracleString = false)
{
Configuration configuration = OpenCustomConfigFile();
Oracle.ManagedDataAccess.Client.OracleConnectionStringBuilder oracleConnectionStringBuilder = new Oracle.ManagedDataAccess.Client.OracleConnectionStringBuilder();
oracleConnectionStringBuilder.DataSource = GetConfigValue(configuration, "DataSource_" + name);
oracleConnectionStringBuilder.UserID = GetConfigValue(configuration, "UserID_" + name);
oracleConnectionStringBuilder.Password = Decrypt(GetConfigValue(configuration, "Password_" + name));
if (isOnlyOracleString)
{
return oracleConnectionStringBuilder.ToString();
}
EntityConnectionStringBuilder entityConnectionStringBuilder = new EntityConnectionStringBuilder();
entityConnectionStringBuilder.Provider = "Oracle.ManagedDataAccess.Client";
entityConnectionStringBuilder.ProviderConnectionString = oracleConnectionStringBuilder.ToString();
entityConnectionStringBuilder.Metadata = string.Format("res://*/Model.EFModel_{0}.csdl|res://*/Model.EFModel_{1}.ssdl|res://*/Model.EFModel_{2}.msl", name, name, name);
return entityConnectionStringBuilder.ToString();
}