ADO.NET makes developing for different databases harder

| Bookmark This! |StumbleUpon | | | | Comments (0)

Hmm... I suddenly realized that my focus these days is development. Interesting.

I'm wondering if there is an easier way for a .NET application to natively support different databases in the same code base. For instance, when I do SQL Server, the .NET Data Provider I would use is SqlConnection. If it is OLEDB, then it's the OleDbConnection namespace.

Now each of these namespaces have their own DataReader object, which is the primary data object I use. How can I write the application such that I can automatically choose which one to use (based on a parameter), without coding different sections for each data provider?

MSDN, here I come!

Leave a comment

December 2009

Sun Mon Tue Wed Thu Fri Sat
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

About


donny direstraits
Constant preoccupation with life-long learning and thinking about our increasingly digital lifestyle. A bit of books, badminton and incessant rambling calms my nerves.