SQLConnection vs OLEDbConnection

[Greg J]

What is the difference when using SQLConnection and SQLX classes or
OleDbConection and OleDbXXX classes for database manipulation in
multiuser (e.g. 100 users) environment?

Can both handle connection pooling etc. or what might be the reason
when selecting from these two DB class categories?


Cheers!

 

[Nicholas Paldino [.NET/C# MVP]]

Greg,

If you are dealing with SQL Server, and you know you are, then you will
want to use the SQL classes. If you are dealing with another DB technology
that doesn't have a native provider, but an OLE DB provider, then use that.

IMO, you should only use the OLE DB provider when you have an OLE DB
provider for a database but no managed provider (like the classes in the
System.Data.SqlClient namespace).

Hope this helps.