By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,034 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,034 IT Pros & Developers. It's quick & easy.

Best database objects??

P: n/a
Hi,

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

Thanks,
Nov 15 '05 #1
Share this Question
Share on Google+
2 Replies


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

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

"Bernardo" <bp****@sapo.pt> wrote in message
news:0a****************************@phx.gbl...
Hi,

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

Thanks,

Nov 15 '05 #2

P: n/a
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
"Bernardo" <bp****@sapo.pt> wrote in message
news:0a****************************@phx.gbl...
Hi,

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

Thanks,

Nov 15 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.