SQLCommand/SQLConnection vs OleDbCommand/OleDbConnection

.net, ado.net, oledb, oledbconnection, sqlconnection

Solution

`OleDbCommand` and `OleDbConnection` are general. `SqlCommand` and `SqlConnection` are specific to SQL Server, and can take advantage of its features. They also expose the features of SQL Server. For instance, you can use them to manipulate XML columns.

Problem

Does it make a difference whether I use `SQLCommand`/`SQLConnection` instead of `OleDbCommand`/`OleDbConnection`. Do I get any advantages out of that, from a API comfortability, feature, performance or security perspective? Or any other perspective?

Original source