RECORDSET vs DATASET

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?
LVL 1
dwopsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AlexFMCommented:
You can continue using recordsets without any problems.
0
GoodJunCommented:
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
dwopsAuthor Commented:
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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

mmarinovCommented:
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
Geo123Commented:
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
liebrandCommented:
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
SRigneyCommented:
.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
Bob LearnedCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dwopsAuthor Commented:
thanks everybody
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.