Data Insertion Updation Deletion in Multiple DBs

Hi,

I am developing an application in VS.net 2002 or 2003 using VB.net that will have the facility of connecting to Access, SQL Server or MySql depending on criteria.

What will be the best way to connect to DBs?

I am making few generic functions that will return me Connection and Adapter objects of relevant database.

What is the best way to Inert , Update and Delete data? Should I populate Datasets? or should I use Command object for data manipulation?

is something like ds("") = value (old ADO style code) is still in use?

Any code suggestion or link to some example will be ppreciated.

Thanks

[613 byte] By [FahadHabib] at [2007-12-16]
# 1

Hi,

You would to look here:

DataLayer.Primitives
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=170&SiteID=1

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

JavierLuna at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...
# 2

Some other links that might be helpful:

Database-independent ADO.Net 2.0 features discussed:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/vsgenerics.asp

Modifying data in ADO.Net 2.0:
http://msdn2.microsoft.com/en-us/library/ms254950.aspx

General ADO.Net resources:
http://msdn2.microsoft.com/en-us/library/ms254505.aspx

alazela at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...

.NET Development

Site Classified