open navigation menu
AiFolder
Tools for a smarter you
Discover
Tools
AI
Games
Interviews
Blog
More
Search AiFolder
Toggle theme
Toggle theme
Sign in
Exit
00:00
Submit test
ADO.NET · Advanced
10 questions · Question 1 of 10
10%
Multiple Choice
Expert
What is the best and fast way to insert 2 million rows of data into SQL Server?
A
SqlDataReader: Holds the connection open until you are finished (don't forget to close it or use using).
B
You can try with SqlBulkCopy class.
C
ADO.NET uses a technique called connection pooling, which minimizes the cost of repeatedly opening and closing connections.
D
ADO.NET components categorized in three modes: disconnected, common or shared and the .NET data providers.
Previous
Next