Different database namespaces

Using (or providing) Microsoft.NET Classes

Different database namespaces

Postby neeraj on Thu Mar 26, 2015 4:29 am

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.
neeraj
 
Posts: 78
Joined: Wed Dec 02, 2009 12:10 am
Location: Ithaca, NY, USA

Re: Different database namespaces

Postby norbertjurkiewicz84 on Thu Mar 26, 2015 4:34 pm

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
User avatar
norbertjurkiewicz84
 
Posts: 55
Joined: Mon Nov 01, 2010 7:26 pm


Return to Microsoft.NET

Who is online

Users browsing this forum: No registered users and 1 guest