Connection Strings - SQL Server

Description	Example
SQL Server Authentication	`Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;`
Windows Authentication	`Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;`

For much more detail, see www.connectionstrings.com

Entity Data Model¶

<add
  name="EntityDataModel"
  connectionString="metadata=res://*/EntityDataModel.csdl|res://*/EntityDataModel.ssdl|res://*/EntityDataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;myConnectionString&quot;"
  providerName="System.Data.EntityClient"
  />

Code First¶

<add name="SmartDataModel" 
      connectionString="myConnectionString"
      providerName="System.Data.SqlClient"
      />