You are developing an application that includes thefollowing code segment. (Line numbers are included
for reference only.)
The GetAnimals() method must meet the following requirements:
-Connect to a Microsoft SQL Server database.
-Create Animal objects and populate them with data from the database.
-Return a sequence of populated Animal objects.
You need to meet the requirements.
Which two actions should you perform? (Each correctanswer presents part of the solution. Choose two.)
A.
Insert the following code segment at line 16: while (sqlDataReader.NextResult())
B.
Insert the following code segment at line 13: sqlConnection.Open();
C.
Insert the following code segment at line 13: sqlConnection.BeginTransaction();
D.
Insert the following code segment at line 16: while (sqlDataReader.Read())
E.
Insert the following code segment at line 16: while (sqlDataReader.GetValues())
B.
Insert the following code segment at line 13: sqlConnection.Open();
D.
Insert the following code segment at line 16: while (sqlDataReader.Read())
yes option B and D
we opne and read …database
we open and read …database
“return customers” must be replaced by “return animals”
B and D