These tests compare the time in milliseconds it takes to do either direction framework or SnapDAL method calls, such as to create a parameter or set it's value, or they compare common database execution times. All tests are performed with the following database providers:

• Vanilla SqlClient call - a standard call to SqlServer using strongly typed SqlCommand objects
• Vanilla OLEDB call - a standard call to SqlServer using strongly typed OleDbCommand objects
• Vanilla ODBC call - a standard call to SqlServer using strongly typed OdbcCommand objects
• SqlClientProviderRunner - a standard call to SqlServer using SnapDAL's SqlClient factory provider
• OleDBProviderRunner - a standard call to SqlServer using SnapDAL's OleDb factory provider

Comparison of CreateParameter factory call

Comparison of Set Parameter Value factory call

Comparison of a database call that includes execution with a transaction

Comparison of execution of a parameterized query

Comparison of execution of an unparamterized query