What is Disconnected
Architecture?
- In traditional mechanism of data access you have to establish a connection to Database Server and then interact to perform actions. In this application stays connected with the Database Server even it does not have any work and waste the Database resources.
- ADO.NET solve this problem by managing the cache locally with the data of Database. For that ADO.NET introduce the DataSet a disconnected object. In this application does not need to stay connected with the Database Server if there is no work. In this you only connect to Database Server when you need to manipulate data in Database and after that you can release the resource for Database Server or disconnect from Database Server.
What is ADO.NET?
- ADO.NET separates the data access
mechanism, data manipulation mechanism and connection to data source. ADO.NET
has number of classes to perform these mechanism.
- ADO.NET can be used by any language
supported by .NET Framework.
- ADO.NET is just a concept not a programming
language.
- ADO.NET provides functionality to work
offline with the data.
- ADO.NET shares number of features of .NET
Framework:
- Multi language support
- Garbage collection
- JIT compilation
- Object Oriented Design
- Dynamic caching
- ADO.NET is set as the core component of any
data driven application or web service.
- ADO.NET introduces the concept of disconnected
architecture.
