You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
The application analyzes large amounts of transaction data that are stored in a different database.
You write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new SqlConnection(sourceConnectionString))
02 using (SqlConnection connection2 = new SqlConnection(destinationConnectionString))
03 using (SqlCommand command = new SqlCommand())
04 {
05 connection.Open();
06 connection2.Open();
07 using (SqlDataReader reader = command.ExecuteReader())
08 {
09 using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection2))
10 {
11
12 }
13 }
14 }
You need to copy the transaction data to the database of the application.
Which code segment should you insert at line 11?
A.
reader.Read();
bulkCopy.WriteToServer(reader);
B.
bulkCopy.DestinationTableName = "Transactions";
bulkCopy.WriteToServer(reader);
C.
bulkCopy.DestinationTableName = "Transactions";
bulkCopy.SqlRowsCopied += new SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied);
D.
while (reader.Read())
{
bulkCopy.WriteToServer(reader);
}