Tutorial by Examples

This example uses SqlConnection, but any IDbConnection is supported. Also any IDbTransaction is supported from the related IDbConnection. public void UpdateWidgetQuantity(int widgetId, int quantity) { using(var conn = new SqlConnection("{connection string}")) { conn.Open()...

Wrapping a group of inserts in a transaction will speed them up according to this StackOverflow Question/Answer. You can use this technique, or you can use Bulk Copy to speed up a series of related operations to perform. // Widget has WidgetId, Name, and Quantity properties public void InsertWidg...