Performance Tips with SqlClient
Here’s a list of things to know if you’d like achieve the best performance/scalability with SqlClient: Use SqlBulkCopy to send large sets of data to the server Set DbDataAdapter.UpdateBatchSize to send batches to the server Use strongly typed getters instead of GetValue/GetSqlValue Turn on CommandBehavior.SequentialAccess and call GetChars/GetBytes when working with BLOBs Use parameterized queries …