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;

        }