OleDB vs. SQL

[Guest]

I'm building an app in vb.net and connecting to a SQL Server 2000 Database.
Does it make a big difference if I use OleDb data adapters as opposed to SQL
data adapters?

Thanks,

 

[Scott M.]

Yes, it does since the data classes in the SQLClient namespace are optimized
for communication with SQL Server.

 

[Guest]

SQL gives you a perf advantage. It may or may not be significant. In
addition, you have SQLTypes you can work with to more easily handle null
types.

OLEDB gives you an advantage if you do not use a DAL and need to switch to
another database in the future (change connection string and roll in many
instances).


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************