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