Which connection string should you add to the .config file?

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?

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)



Leave a Reply 1

Your email address will not be published. Required fields are marked *