Difference between a DataReader, a DataAdapter, a Dataset


DataReader
  • Connection Oriented architecture.
  • DataReader is used to read data from database and it is a read and forward only connection  oriented architecture during fetching data from databaset.
  • DataReader is used to iterate through result set that came from server and it will read one record at a time, that is why memory consumption will be less and it will fetch the data very fast when compared with DataSet. Generally we will use ExecuteReader object to bind data to DataReader.
DataSet
  • Disconnected architecture. This means there is no need of active connections whne we are work with datasets and it is a collection of datatables and relations among tables. It is used to hold multiple tables with data.
  • You can select data from tables and views. Also DataSet provides you with rich features like saving data as XML and loading XML data.
DataAdapter
  • Disconnected architecture.
  • DataAdapter will acts as a bridge between DataSet and database.
  • This DataAdapter object is used to read the data from database and bind that data to dataset.

Comments

Post a Comment

Popular posts from this blog

IIS Performance Improvement

These days in web application, performance is very crucial from user and business point of view. Everyone wants better performance and response from web application. In this tip, I am going to highlight ways to improve performance from Internet information server serving faster web pages to your users. https://www.codeproject.com/Tips/832570/IIS-Performance-Improvement
Read more

Custom error mode off in web config

Three error modes in which an ASP.NET application can work: 1) Off Mode 2) On Mode 3) RemoteOnly Mode The Error mode attribute determines whether or not an ASP.NET error message is displayed. By default, the mode value is set to "RemoteOnly". Off Mode When the error attribute is set to "Off", ASP.NET uses its default error page for both local and remote users in case of an error. <?xml version="1.0" encoding="utf-8" ?> <configuration> <system.web> <customErrors mode="Off" /> </system.web> </configuration> On Mode In case of "On" Mode, ASP.NET uses user-defined custom error page instead of its default error page for both local and remote users. If a custom error page is not specified, ASP.NET shows the error page describing how to enable remote viewing of errors. <? xml version =" 1.0" encoding =" utf-8" ? > < configuration ...
Read more

Dot Net Tips Tricks C # Tips Tricks and Solutions

Being a web developer is not an easy task. Programming in ASP.NET requires a lot of hard work and brains. Many small things seem difficult sometimes and require a lot of time. This could be frustrating and might lead to less productivity. Therefore, this article is aimed to those ASP.NET developers who go through these sort of situations. It will provide them with some .NET tricks that might be of some help to them. Our article would provide some .NET tips and tricks that could make your problems disappear. Apart from that, C# tips will also be provided. First of all, I would like to start by sharing some useful .NET tricks with all the readers. http://www.c-sharpcorner.com/article/tips-and-tricks-of-net-and-c-sharp-and-overview-of-microsoft-big-data-solutions/
Read more