70-483 question 4 discussion

answered

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())
Created 5 days, 18 hours ago by edlias

edlias

We cannot read until the reader is executed