ADO.NET vs ADODB

[Andrzejek]

We are moving all of our code from VB 6.0 to VB.NET 2008. One big application - about 150 forms, several bas modules, a lot of reports, mostly in Excel, but also in Word and CrystalReoprt.

All of our code is basically ADODB: one connection to ORACLE, building recordsets, sending Updates, Inserts and Deletes.

Now, moving to VB.NET, we can all redo our ADODB with no much of changes to our code (short learning curve), but we can also go with ADO.NET about which I don't know much - ie. more learning for me and my co-workers.

What would be the benefits of moving to ADO.NET?



Have fun.

---- Andy

 

[RiverGuy]

Here's a good starting point:

http://msdn.microsoft.com/vbrun/staythepath/additionalresources/upgradingvb6/chapter20.pdf