Solved

RECORDSET vs DATASET

Posted on 2003-12-02
9
1,144 Views
Last Modified: 2007-12-19
hey, i keep reading in different places that the whole VB6/ADO recordset concept is now obsolete in VB.Net and has been replaced by ADO.Net, Datasets and DataAdaptors.  In some situations I still find ADO recordsets more usefull and easier to work with.  Is there a reason I should stay away from them in .Net or do you guys, like me, find yourself still using them in certain situations?
0
Comment
Question by:dwops
9 Comments
 
LVL 48

Expert Comment

by:AlexFM
ID: 9858974
You can continue using recordsets without any problems.
0
 
LVL 10

Expert Comment

by:GoodJun
ID: 9859041
ADO recordset is obsolete. If you use .net, then switch to ado.net, it may need some get used to, but you will be there eventually.
0
 
LVL 1

Author Comment

by:dwops
ID: 9859142
so, who's right, is it obsolete or should i keep using it?  are there any specific disadvantages or is it just personal opinion?
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 28

Expert Comment

by:mmarinov
ID: 9859162
you will find situations that may be record set is more usefull , but this will be only a matter of time
once you get used to wth ado.net you will work more easily

B..G
0
 
LVL 3

Expert Comment

by:Geo123
ID: 9859362
err how about recordsets dont exist in VB.net.... Datasets are king. I know its a shock concept... but once you start using they are easy and can be related to 1.

cheers George
0
 
LVL 15

Expert Comment

by:liebrand
ID: 9859386
If you are using .NET do not use recordsets... definitely switch to ADO.NET -- once you start using it more you will see it has its advantages and it way better!
0
 
LVL 15

Assisted Solution

by:SRigney
SRigney earned 25 total points
ID: 9860837
.Net does offer more advantages than traditional ADO recordsets.  The sorting and filtering functionality work faster.  If you are connecting to SQL Server 7 or 2000 then the data access is faster, even if you are not the data access should be faster.  When you use traditional ADO in .Net, which you can do, you have to go through an interop to go between managed and unmanaged code.  This reduces the efficiency of the data access.

ADO is not officially dead, but it is a really (let me put a stress) REALLY good idea to use ADO.net when writing your application in .NET.  I have yet to see anything that you can do in the old version of ADO that ADO.Net does not also handle.  The only reason that I can think to keep using the older ADO is familiarity, but that will never change if you don't start using ADO.Net.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 25 total points
ID: 9860960
ADO can be used, but since it is built on COM technology there has to be an additional layer added to .NET to give you access to it methods, properties, and events.  I realize that a lot of programmers have difficulty letting go of what they know and are comfortable with.  Micro$oft has rebuilt ADO in a new beast called ADO.NET, and a lot of things are built around this new technology.  Slowly but surely ADO will become a thing of the past, a dinosaur like DAO.  

So get on board, move into the future, and keep up with Jones', and learn about DataAdapters, DataSets, and all the other periphery.
0
 
LVL 1

Author Comment

by:dwops
ID: 9861131
thanks everybody
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

807 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