/// <summary>
/// EF DataBase First 动态拼接数据库连接
/// </summary>
/// <param name="edmxFullName">创建EF实体时的命名(也是数据库实体名称)</param>
/// <param name="connectionStringName">连接字符串的名称</param>
/// <returns>返回解密后的链接字符串</returns>
public static string EFDecryptDESConnectionString(string edmxFullName,string connectionStringName)
{
//dbConnectionString是自定义变量,不用在意
if (!dbConnectionString.Keys.Any(o => o == connectionStringName))
{
string DESConnectionString = DecryptDES(ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString, CONNECTIONSTRINGDESKEY);
string[] DESConnectionStringArr = DESConnectionString.Split('|');
//以下是主要部分,这里开始才是重点,连接字符串是以“|”分割保存在配置文件中的
System.Data.EntityClient.EntityConnectionStringBuilder entityConnectionStringBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();
entityConnectionStringBuilder.Metadata = "res://*/" + edmxFullName + ".csdl|res://*/" + edmxFullName + ".ssdl|res://*/" + edmxFullName + ".msl";
entityConnectionStringBuilder.Provider = "System.Data.SqlClient";
SqlConnectionStringBuilder sqlConnectionStringBuilder = new SqlConnectionStringBuilder();
sqlConnectionStringBuilder.DataSource = DESConnectionStringArr[0];
sqlConnectionStringBuilder.InitialCatalog = DESConnectionStringArr[1];
sqlConnectionStringBuilder.IntegratedSecurity = false;
sqlConnectionStringBuilder.UserID = DESConnectionStringArr[2];
sqlConnectionStringBuilder.Password = DESConnectionStringArr[3];
sqlConnectionStringBuilder.MultipleActiveResultSets = true;
sqlConnectionStringBuilder.ApplicationName = "EntityFramework"";
entityConnectionStringBuilder.ProviderConnectionString = sqlConnectionStringBuilder.ToString();
dbConnectionString.Add(connectionStringName, entityConnectionStringBuilder.ConnectionString);
}
return dbConnectionString[connectionStringName];
}
EF DataBase First 动态拼接数据库连接
最新推荐文章于 2024-07-01 16:30:55 发布