Solved

Switching from ADO > ADO.NET

Posted on 2006-10-24
5
195 Views
Last Modified: 2010-04-23
Hello,

I have a few programs that are written in VB.NET with ADO.  I want to switch this to ADO.NET.  The code is fairly well OO.  I have a ton of data sets, will i need to re-create the data sets?  If there are any big fall backs or hudles in doing this let me know.

thanks!

-Navicerts
0
Comment
Question by:Navicerts
  • 2
  • 2
5 Comments
 
LVL 14

Expert Comment

by:ptakja
ID: 17799608
Should be pretty straight forward. You should see a BIG performance boost!
0
 
LVL 7

Author Comment

by:Navicerts
ID: 17802713
I work with small local record sets in a disconnected environment; things run fairly instantaneously as it is.  Is there still reason to upgrade it?
0
 
LVL 14

Accepted Solution

by:
ptakja earned 250 total points
ID: 17802828
For one, ADO.NET is managed code. This means that it will be more efficient than running through COM Interop which adds an extra layer for all your calls into ADO. Further, upgrades to future versions of Visual Studio may not support ADO as we get further and further away from VB 6.

You are "currently" working with small recordsets in a disconnected environment. But what happens when you transition to a larger enterprise-scale project? That's where knowing ADO.NET will really pay off. My suggestion is to bite the bullet on a small managable project where you can really take the time to learn how this stuff works.

0
 
LVL 41

Assisted Solution

by:graye
graye earned 250 total points
ID: 17802937
The most troublesome part of the transition from ADO to ADO.Net is grasping the philosophy of a "disconnected recordset".   In ADO.Net everything is inheritantly "disconnected".

A "disconnected" database model is one where your application makes a connection to the database long enough to take a snapshot of the data and then disconnects... you then add/delete/modify the data that is cached locally on your PC... and when you're ready, you reconnect to the database and merge your locally cached changes back to the original database.

I've got programs where the disconnected model doesn't work well (a data "pump" applications that reads a row from one database and writes it to another database).   In those situations, Microsoft recommends that you keep using the "classic" ADO, rather than ADO.Net

... your mileage will vary...
0
 
LVL 7

Author Comment

by:Navicerts
ID: 17803066
Interesting stuff.  Sounds like i might be able to take advantage of some of this stuff.  I'm going to take your advice and use ADO.net in the next project i do.  If for no other reason than someday ADO will not be supported :)

Thanks for the tips and advice guys!

-Navicerts
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
This video discusses moving either the default database or any database to a new volume.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now