Best database objects??

[Bernardo]

Hi,

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

Thanks,

 

[Miha Markic]

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

 

[John Puopolo]

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