- Database Connection - Datereader requires an open database connection whereas Dataset does not require an open database connection
- Namespace - Datereader belongs to System.Data.SqlClient or System.Data.OleDB whereas Dataset belongs to System.Data
- Record Set - Datereader is forward only and read only whereas Dataset is not forward only and read only
- Data Source - Datereader can get data from managed data provider. Data cannot be loaded manually whereas Dataset can get data from managed data provider .Data can be loaded manually by XML etc.
- Performance - DataReader has faster retrival and better performance then Dataset
What is difference between Dataset and DataReader ?
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Below is indexer declaration : modifier return type this [argument list] { get { // Get codes goes here } set { // Set codes goes h...
-
1. An indexer is identified by it's signature. But a property is identified it's name. 2. An indexer is always an instance member,...
-
You can add public events for Httpmodule using below syntax i.e ModuleName_OnEventName in Global.asax . Example Session_OnStart ( Obj...
-
The steps to create custom HTTP module are : Implement IHttpModule Interface Handle Init Method and register events one needs Handle t...
-
Use a delegate when: An eventing design pattern is used. • It is desirable to encapsulate a static method. The caller has no need access o...
-
Please do below steps to make SQLServer session mode to work properly : 1. To use SQLServer mode, you must first be sure the ASP.NET sessi...
-
Different access modifiers/specifiers in C# : Public - Any class or assembly can access Protected - Access is limited to the containing ...
-
Replication is the way to keep data synchronised in multiple datbases. SQL Replication consists of two important part : Publisher - Datab...
-
OOPs concepts that C# supports are : Abstraction : is a process that involves identifying the crucial behavior of an object and eliminatin...
-
public class Operation { public int Add ( int a , int b ) { return (a+b); } } We have to call above method using delegate Steps below : D...
Posts
No comments:
Post a Comment