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

      

  • 相关阅读:
    flex布局
    媒体查询
    transform详细解释
    读取long类型数据
    Oracle中快速清空当前用户的所有表数据
    没有表头的csv文件怎么导入Kettle
    Kettle性能调优汇总
    oralce中特殊字符的查询
    数据的单值、多值、派生、简单、复合属性
    kettle学习
  • 原文地址:https://www.cnblogs.com/lmBlock/p/4133680.html
Copyright © 2020-2023  润新知