1. Web.Config Connection String
<configuration> <connectionStrings>
<add name="myConnection" connectionString="server=localhost;database=mydatabase;" /> </connectionStrings> </configuration>
2. Get connection string using the
ConfigurationManager class:
string conn = ConfigurationManager.ConnectionStrings["myConnection"].ConnectionString;
3. EF Reference Connection String in DB Context Ctor:
public class DatabaseContext : DbContext {
public DatabaseContext() : base("myConnection")
{ } }
4. SQL Server Connection String Integrated Security:
<connectionStrings>
<add name="sqlServer" providerName="System.Data.SqlClient" connectionString="Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=True;" /> </connectionStrings>
5. SQL Server Connection String SQL Authentication:
<connectionStrings>
<add name="sqlServer" providerName="System.Data.SqlClient" connectionString="Data Source=localhost;Initial Catalog=MyDatabase;User Id=user;Password=pwd;" /> </connectionStrings>
6. My SQL Connection String:
<connectionStrings>
<add name="mySql" providerName="MySql.Data.MySqlClient" connectionString="Server=localhost;Database=MyDatabase;Uid=user;Pwd=pwd;" /> </connectionStrings>
7. Oracle Connection String
Data Source=ABC.Company.OraDSName;User Id=myUid;Password=mypwd;
8. SQL Server by Database Name
<add name="MyDBStage" connectionString="Database=MyDBStage;Server=.\sql2012;Integrated Security=SSPI;"
providerName="System.Data.SqlClient" />
9. Connection String using Model:
<connectionStrings>
<add name="MyDBEntities" connectionString="metadata=res://*/Data.MyDB.csdl|res://*/Data.MyDB.ssdl|res://*/Data.MyDB.msl;provider=System.Data.SqlClient;provider connection string="data source=SP2013E\SPSQL;initial catalog=MyDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
</connectionStrings>
10. MS Dynamics Connection String
<add name="Xrm" connectionString="Server=
http://myCompany.crm5.dynamics.com; Domain=myCompany; Username=myUserId@myCompany.com.au; Password=Secret0102"/>
</connectionStrings>
11. Named Connection String Integrated Security:
<add name="MyDBConnString" connectionString="Database=MyDB;Server=MyServer;Integrated Security=SSPI;"
providerName="System.Data.SqlClient" />
</connectionStrings>
12. References:
Connection Strings Samples
MS Connection Strings
Guide to Connection Strings
