1.Dataset is a DISCONNECTED object model for working with the data fetched from database.
2.It is completely independent of the database and because of which we can fetch the data from different database into the same dataset instance.
3.Because it is a disconnected model it reduces the number of trips to the server and thus it reduces the load on server. This increases server’s scalability. (Scalability is the measure of server capability to handle increasing number of clients)
4.Due to this the data is available locally and the client doesn’t have to make a round trip to the server for every requirement, This reduces network traffic and also client applications performance is improved.
5.It can be used for exchanging of data between distributed objects.
6.Because it can easily interoperate with XML it can be used for communication between objects even if they are seperated by firewall.
7.Dataset mainly has DataTable and DataRelation. The DataTable again will have DataColoum, DataRow and Constraints.
If readonly and forward only access to data is required then it preferred to use DataReader instead of DataSet. This is because constructing a dataset requires constructing objects representing the data fetched from backend and this would require large amount of memory on the client and thus can also degrade performance.
Get the best Interview Question for ADO.NET at bestdotnettraining
2.It is completely independent of the database and because of which we can fetch the data from different database into the same dataset instance.
3.Because it is a disconnected model it reduces the number of trips to the server and thus it reduces the load on server. This increases server’s scalability. (Scalability is the measure of server capability to handle increasing number of clients)
4.Due to this the data is available locally and the client doesn’t have to make a round trip to the server for every requirement, This reduces network traffic and also client applications performance is improved.
5.It can be used for exchanging of data between distributed objects.
6.Because it can easily interoperate with XML it can be used for communication between objects even if they are seperated by firewall.
7.Dataset mainly has DataTable and DataRelation. The DataTable again will have DataColoum, DataRow and Constraints.
If readonly and forward only access to data is required then it preferred to use DataReader instead of DataSet. This is because constructing a dataset requires constructing objects representing the data fetched from backend and this would require large amount of memory on the client and thus can also degrade performance.
Get the best Interview Question for ADO.NET at bestdotnettraining
Comments
Post a Comment