ExamGuru IT/.Net Guru : DataSet-Class VS DataReader-Class on ASPFriends.com 'ngfx-patterns' list

.NETGURU

DataSet-Class VS DataReader-Class

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-patterns' list.

Adnan Qamar

Can someone tell me in an overloaded environment, should DataReader class be
used instead of DataSet class to access the database server?

Reply to this message...

Scott Worley

<html><div style='background-color:'><DIV>
<DIV>
<P>Hi Adnan,</P>
<P>Depends on your usage of the class to be honest, as always it goes down to performance, and which is the better, you can use the brief list below as a guide:</P>
<P>Use a dataset for complex data relationships, and cache it or its dataviews and copy those into you class fields/collections, remember cached data works is a lot faster to access than when it is stored on a database server. (you can also use a cached dataview, and loop through it to populate, your class fields and collections, again with great speed)</P>
<P>Use a datareader to load you class fields/collections, when the datasource is used less frequently, and would not benifit from caching. </P>
<P>Thats it, if you have more queries on these technique please ask.</P>
<P> </P>
<P>Scott Worley, <A href="mailto:Click here to reveal e-mail address">Click here to reveal e-mail address</A></P>
<P> Author of: Inside ASP.NET, New Riders Publishing, Nov 2001.</P>
<P> Working on: Commerce Server 2002 and .NET Unleashed, SAMS<BR><BR></P></DIV>
<DIV></DIV>
<P><BR><BR><BR>Respect & Honour </P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P>Scott Worley </P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P> </P>
<P>----Original Message Follows---- </P>
<DIV></DIV>
<P>From: Adnan Qamar <Click here to reveal e-mail address></P>
<DIV></DIV>
<P>Reply-To: "ngfx-patterns" <Click here to reveal e-mail address></P>
<DIV></DIV>
<P>To: "ngfx-patterns" <Click here to reveal e-mail address></P>
<DIV></DIV>
<P>Subject: [ngfx-patterns] DataSet-Class VS DataReader-Class </P>
<DIV></DIV>
<P>Date: Fri, 1 Mar 2002 10:27:06 +0530 </P>
<DIV></DIV>
<DIV></DIV>
<P>-- Moved from [aspngcs] to [ngfx-patterns] by Charles M. Carroll <Click here to reveal e-mail address>-- </P>
<DIV></DIV>
<DIV></DIV>
<P>This message is in MIME format. Since your mail reader does not understand </P>
<DIV></DIV>
<P>this format, some or all of this message may not be legible. </P>
<DIV></DIV>
<DIV></DIV>
<P>------_=_NextPart_001_01C1C0DD.894F7310 </P>
<DIV></DIV>
<P>Content-Type: text/plain; </P>
<DIV></DIV>
<P>charset="iso-8859-1" </P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P>Can someone tell me in an overloaded environment, should DataReader class be </P>
<DIV></DIV>
<P>used instead of DataSet class to access the database server? </P>
<DIV></DIV>
<DIV></DIV>
<P>------_=_NextPart_001_01C1C0DD.894F7310 </P>
<DIV></DIV>
<P>Content-Type: text/html; </P>
<DIV></DIV>
<P>charset="iso-8859-1" </P>
<DIV></DIV>
<P>Content-Transfer-Encoding: quoted-printable </P>
<DIV></DIV>
<DIV></DIV>
<P><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"></P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P>
<META content='3D"text/html;' http-equiv='3D"Content-Type"' ="</DIV">charset=3Diso-8859-1"> </P>
<DIV></DIV>
<P>
<META content='3D"MS' name='3D"Generator"' version="</DIV" Server Exchange>5.5.2650.12"> </P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P><BR> </P>
<DIV></DIV>
<DIV></DIV>
<P><FONT face='3D"Arial"' size=3>Can someone tell me in an overloaded =
<DIV></DIV>
<P>environment, should DataReader class be used instead of DataSet = </P>
<DIV></DIV>
<P>class to access the database server?</FONT> </P>
<P></P>
<DIV></DIV>
<DIV></DIV>
<P>| [ngfx-patterns] member Click here to reveal e-mail address = YOUR ID </P>
<DIV></DIV>
<P>| http://www.aspfriends.com/aspfriends/ngfx-patterns.asp = JOIN/QUIT </P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P>------_=_NextPart_001_01C1C0DD.894F7310-- ----Original Message Follows---- </P></DIV>
<DIV></DIV>From: Adnan Qamar <Click here to reveal e-mail address>
<DIV></DIV>Reply-To: "ngfx-patterns" <Click here to reveal e-mail address>
<DIV></DIV>To: "ngfx-patterns" <Click here to reveal e-mail address>
<DIV></DIV>Subject: [ngfx-patterns] DataSet-Class VS DataReader-Class
<DIV></DIV>Date: Fri, 1 Mar 2002 10:27:06 +0530
<DIV></DIV>
<DIV></DIV>-- Moved from [aspngcs] to [ngfx-patterns] by Charles M. Carroll <Click here to reveal e-mail address>--
<DIV></DIV>
<DIV></DIV>This message is in MIME format. Since your mail reader does not understand
<DIV></DIV>this format, some or all of this message may not be legible.
<DIV></DIV>
<DIV></DIV>------_=_NextPart_001_01C1C0DD.894F7310
<DIV></DIV>Content-Type: text/plain;
<DIV></DIV>charset="iso-8859-1"
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>Can someone tell me in an overloaded environment, should DataReader class be
<DIV></DIV>used instead of DataSet class to access the database server?
<DIV></DIV>
<DIV></DIV>------_=_NextPart_001_01C1C0DD.894F7310
<DIV></DIV>Content-Type: text/html;
<DIV></DIV>charset="iso-8859-1"
<DIV></DIV>Content-Transfer-Encoding: quoted-printable
<DIV></DIV>
<DIV></DIV><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<META content='3D"text/html;' http-equiv='3D"Content-Type"' ="</DIV">charset=3Diso-8859-1">
<DIV></DIV>
<META content='3D"MS' name='3D"Generator"' version="</DIV" Server Exchange>5.5.2650.12">
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV><BR>
<DIV></DIV>
<DIV></DIV>
<P><FONT face='3D"Arial"' size=3>Can someone tell me in an overloaded =
<DIV></DIV>environment, should DataReader class be used instead of DataSet =
<DIV></DIV>class to access the database server?</FONT>
<P></P>
<DIV></DIV>
<DIV></DIV>| [ngfx-patterns] member Click here to reveal e-mail address = YOUR ID
<DIV></DIV>| http://www.aspfriends.com/aspfriends/ngfx-patterns.asp = JOIN/QUIT
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>------_=_NextPart_001_01C1C0DD.894F7310--
<DIV></DIV>
<DIV></DIV></div><br clear=all><hr>MSN Photos is the easiest way to share and print your photos: <a href='http://g.msn.com/1HM105301/14'>Click Here</a><br></html>

Reply to this message...

System.Data.DataSet

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification