首页 > 学院 > 开发设计 > 正文

EF之MSSQL分布式部署一:EFContext自定义数据库链接

2019-11-17 02:43:44
字体:
来源:转载
供稿:网友

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;        } 

  


发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表