No nonsense, on the code: Source: http://bbs.csdn.net/topics/390823046 Original address: EF's MSSQL Distributed deployment one: Efcontext Custom database links
<summary>///Get the connection string for entity///</summary>//<param name= "Edmxfullname" >EDMX includes the full name of the namespace </param>//<param name= "Server" > server address or name </param>//<param name= " Dadabase "> Database </param>//<param name=" usr "> User </param>//<param name=" pswd "> Password & lt;/param>//<param name= "AppName" > Program name </param>//<returns>entity connection string </returns& Gt public static string Getentityconnectionstring (string edmxfullname, String server, String dadabase, String usr, string psw D, String appName) {System.Data.EntityClient.EntityConnectionStringBuilder Entityconnectionstringbuilde R = 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's MSSQL Distributed deployment one: Efcontext Custom database links