Dapper is a micro-ORM for .Net that extends your IDbConnection, simplifying query setup, execution, and result-reading.
Type Handlers allow database types to be converted to .Net custom types.
The syntax for expressing parameters varies between RDBMS. All the examples above use SQL Server syntax, i.e. @foo; however, ?foo and :foo should also work fine.
The WriteToServer and WriteToServerAsync have overloads that accept IDataReader (seen in the examples), DataTable, and DataRow arrays (DataRow[]) as the source of the data for the Bulk Copy.