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


    不废话,上代码:
    来源:http://bbs.csdn.net/topics/390823046
     
            /// <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;
            } 
    

      

  • 相关阅读:
    上海第八中学 shader
    http://www.riemers.net/
    手写板驱动
    使用dos 作为中介实现cpython 和c# 交互
    判断一个点是不是在三角形中 用面积算法
    Python os.chmod
    Python 的stat 模块
    文件格式说明
    win7 一切软件都安装不上 解决 把他卸掉
    执行力
  • 原文地址:https://www.cnblogs.com/lmBlock/p/4133680.html
Copyright © 2020-2023  润新知