Solved

Switching from ADO > ADO.NET

Posted on 2006-10-24
5
224 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

828 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