Oledb.net vs ODBC.net

[tommyfan]

All,
Im going to move to .net and need to decide
which data provider that Im going to use.
Currently my app is using SQL Server but it should
be able to run on other DBMS. So it looks like that
Id better use oledb.net but however Microsoft also
offered an add-in odbc.net. Can someone tell me,
I would like to know, what the advantage and
disadvantage of between using Oledb.net and Odbc.net ?

I need some advice.

Thanks.

 

[TechnoTone]

If I remember correctly, in the past ODBC acted as a wrapper to OLEDB when accessing SQL Server. The general consesus was that if you could use OLEDB then do so.

I dont know if this has changed with .NET.

 

[quwiltw]

Id create a DBFactory that creates all instances for you and have all your data access code interface-based. That way you can change later but for now you get the performance benefits of the SQL Server Data Provider.