In traditional data access components, you make a connection to database and then interact with DB through SQL queries using the connection. The application stays connected to the DB system even when it is not using DB services. This commonly wastes the valuable and expensive DB resource as most of the time applications only query and view the persistent data.
ADO.Net solves this problem by managing a local buffer of persistent data called Dataset. Your application automatically connects to the DB server when it needs to pass some query and then disconnects immediately after getting the result back and storing it in dataset.
0 comments :
Post a Comment