Best database objects??

  • Thread starter Thread starter Bernardo
  • Start date Start date
B

Bernardo

Hi,

Anyone knows what are the best database objects?
The COM ADO is better then Data.OleDb or Data.SqlClient?

Thanks,
 
You should use native managed providers (SqlClient).
You should use com ado only as a last resort (if nothing else works)
 
Bernardo:

COM ADO is used for legacy code. That aside, the COM ADO model is
fundamentally based on a "connected" model, while the .NET objects are based
on a "connection-less" model.

In .NET, use the .NET providers where you can.

John
 
Back
Top