Different database namespaces

[neeraj]

If you do database programming you should be aware that the .NET libraries provide for 5 different namespaces depending upon which Database you want to use. These are

System.Data.Odbc
System.Data.OleDb
System.Data.OracleClient
System.Data.SqlServerCe
System.Data.SqlClient

Figuring out which one to use is left as an exercise for the reader.

[norbertjurkiewicz84]

I believe a DatabaseFactory model should take care of many issues this presents. I've never implement it in APL but it should be doable to write a nice cover class.

There are also third party providers that implement a single interface for multiple databases.

http://www.c-sharpcorner.com/UploadFile ... n-pattern/


Norbert