Solved

Switching from ADO > ADO.NET

Posted on 2006-10-24
5
238 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

623 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