You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application includes a server component that receives DataTable objects from client components.
Each DataTable object contains approximately 2,500,000 rows.
The server component must load new and updated records from the DataTable objects into a table in a Microsoft SQL Server 2005 database.
The schemas of the database table and the DataTable objects are identical. The database is located on a different server than the application server component.
You need to identify a method that provides the best performance to load the data into the database table.
Which method should you use?
A.
Use the bcp utility.
B.
Use a SqlBulkCopy object.
C.
Use the BULK INSERT statement.
D.
Use a parameterized stored procedure.