SqlConnection conn = new SqlConnection( "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI");
The SqlConnection object instantiated above uses a constructor with a single argument of type string. This argument is called a connection string. Table 1 describes common parts of a connection string.
Table 1. ADO.NET Connection Strings contain certain key/value pairs for specifying how to make a data base connection. They include the location, name of the database, and security credentials.