首页 > 代码库 > EF之MSSQL分布式部署一:EFContext自定义数据库链接
EF之MSSQL分布式部署一:EFContext自定义数据库链接
不废话,上代码:
来源:http://bbs.csdn.net/topics/390823046
原文地址:EF之MSSQL分布式部署一:EFContext自定义数据库链接
/// <summary> /// 得到Entity的连接字符串 /// </summary> /// <param name="edmxFullName">Edmx的包括命名空间的全名称</param> /// <param name="server">服务器地址或名称</param> /// <param name="dadaBase">数据库</param> /// <param name="usr">用户</param> /// <param name="pswd">密码</param> /// <param name="appName">程序名称</param> /// <returns>Entity连接字符串</returns> public static string GetEntityConnectionString(string edmxFullName, string server, string dadaBase, string usr, string pswd, string appName) { 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 = server; sqlConnectionStringBuilder.InitialCatalog = dadaBase; sqlConnectionStringBuilder.IntegratedSecurity = true; sqlConnectionStringBuilder.UserID = usr; sqlConnectionStringBuilder.Password = pswd; sqlConnectionStringBuilder.MultipleActiveResultSets = true; sqlConnectionStringBuilder.ApplicationName = appName; entityConnectionStringBuilder.ProviderConnectionString = sqlConnectionStringBuilder.ToString(); return entityConnectionStringBuilder.ConnectionString; }
EF之MSSQL分布式部署一:EFContext自定义数据库链接
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。