You use Microsoft .NET framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database named AdventureWorksLT.
The database resides on an instance named INSTA on a server named SQL01.
You need to configure the application to connect to the database. Which connection string should you add to the .config file?
A.
Data Source=SQL01; Initial Catalog=INSTA; Integrated Security=true; Application Name=AdventureWorksLT;
B.
Data Source=SQL01; Initial Catalog=AdventureWorksLT; Integrated Security=true; Application Name=INSTA;
C.
Data Source=SQL01\INSTA; Initial Catalog=AdventureWorksLT; Integrated Security=true;
D.
Data Source=AdventureWorksLT; Initial Catalog=SQL01\INSTA; Integrated Security=true;
Explanation:
CHAPTER 2 ADO.NET Connected Classes
Lesson 1: Connecting to the Data Store
Configuring an SQL Server Connection String (page 70-71)
http://www.connectionstrings.com/sql-server/
Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;