Solved

ado.net or adodc

Posted on 2004-08-16
6
836 Views
Last Modified: 2008-03-10
I am use to using the adodc in vb6 and I know that you can use it in .net as long as you reference it. Is that a good thing? Meaning should I still continue using it or go straight to hardcoding ado.net???? I will most likely hardcode either way because I find it easier to make changes versus using the wizards....
0
Comment
Question by:hogan9111
6 Comments
 
LVL 6

Expert Comment

by:microbolt
ID: 11817129
I would rewrite your code for ado.net to take advantange of the new .net features and an increase in speed.  Also if you use the .net framework it is one less control that you have to distribute with your application.
0
 
LVL 41

Expert Comment

by:graye
ID: 11817330
Strange term "hardcoding"...  suggesting what?  That ADO.Net is somehow more rigorous and unforgiving than ADO ?!?!  (Not hardly!)

Generally speaking, I'd suggest you go with the "latest and greatest" ADO.Net on new projects, and keep your tried and true ADO for any existing project.
 
However, as you propably already know, ADO.Net is inheritantly provides a "disconnected recordset"...   Microsoft understands that will be times when you really would prefer a traditional connected recordset, so ADO is well supported in VB.Net.

The speed/performance improvements from switching from ADO to ADO.Net will be marginal at best.  In order to get any improvements from the ADO.Net features, you must "think .Net" to begin with... converted an existing program over to ADO.Net (without a redesign) will not provide you any performance improvements.

I tend to think of everything in programming (and life) as a learning experience, so I never shy away from the new stuff.  I'm also pragmatic, and know that an investment in an existing technology is a worthwhile thing.
0
 

Expert Comment

by:dkinjal
ID: 11818264
i have done both ADODC and ado.net, better u go for ado.net... once u will learn the ado.net, you will come to know the power of the architecture... any ya, adodc is a COM control and its OLD tech, now... as far as possible AVIOD using COM components in .NET applications....
one more thing, if u r doing sesrious programming, i mean, if u want to program for long purpose then avoid HardCodding...
-Kinjal
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

Author Comment

by:hogan9111
ID: 11823045
Thank you, I still will probrably hardcode so I know what has been done in case of future growth of the project. thanks though, I will go to ado.net


0
 

Author Comment

by:hogan9111
ID: 11864135
is all ado.net disconnected????

if so then what would happen if you have users working on the same record.

lets say user 1 pulls in the data that user 2 is working on now. user1 would never know what user 2 just did. so user1 makes a update to the record that user2 just changed. I know this sounds confussion, but it just seems that the data will not be in realtime and basically in a batch mode.

Please explain???
0
 
LVL 41

Accepted Solution

by:
graye earned 25 total points
ID: 11864166
That's exactly correct... the data is not in real time, it *is* in a "batch mode".

The Update() method of the DataAdapter object does a pretty good job of figuring out what to do with the additions, deletions, and changes that have occured since the Fill() method grabbed the original data.

There are published rules on how to deal with concurrency issues...  mostly dealing with the "age" of the transaction (rather than the age of the update).  There is a pretty good article at http://www.fawcette.com/vsm/2003_08/magazine/columns/databasedesign/
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
This article will show, step by step, how to integrate R code into a R Sweave document
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

776 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