Which two actions should you perform?

Posted by: Pdfprep Category: 70-483 Tags: , ,

You are developing an application that includes the following code segment. (Line numbers are included for reference only.)

The GetCustomers() method must meet the following requirements:

• Connect to a Microsoft SQL Server database.

• Populate Customer objects with data from the database.

• Return an IEnumerable<Customer> collection that contains the populated Customer objects.

You need to meet the requirements.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A . Insert the following code segment at line 17: while (sqlDataReader.GetValues())
B . Insert the following code segment at line 14: sqlConnection.Open();
C . Insert the following code segment at line 14: sqlConnection.BeginTransaction();
D . Insert the following code segment at line 17: while (sqlDataReader.Read())
E . Insert the following code segment at line 17: while (sqlDataReader.NextResult())

Answer: B, D

Explanation:

B: SqlConnection.Open – Opens a database connection with the property settings specified by the

ConnectionString.

Reference: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.open.aspx

D: SqlDataReader.Read – Advances the SqlDataReader to the next record.

Reference: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.read.aspx

Not E: reader.NextResult is wrong because that is used when reader has more than one result set (SP or inline SQL has more than one Select).

Leave a Reply

Your email address will not be published.