PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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)

One Comment on “Which connection string should you add to the .config file?


Leave a Reply