Illustrate ADO.NET Architecture

The ADO.NET Architecture contains two main components.

• Data Provider – Establishes connection with different databases like Oracle, MS Access and SQL Server. Data Provider contains the following:

o Connection –to establish connectivity with database
o Command Object – to access stored procedures of the database
o Data Adapter – to pass data fetched from the database to the dataset for caching and making the data available even when the connection gets disconnected.
o Datareader – to read data from database

• Dataset – Contains cached data fetched from the different databases. The data is fetched and maintained with the help of Data Adapter.

Communication between these components in ADO.NET architecture is pictorially represented below:

| How do you implement Observer Design Pattern in .NET? | How do you pass data between different Tiers in .NET Architecture? | How is Classic ADO different from ADO.NET? | How is Dataadapter useful in ADO.NET? | How is Datareader different from Dataset in ADO.NET? | How is .NET Application Development different from Traditional Development? | How is HashTable different from ArrayList in .NET? | How is Inheritance achieved in C#? | How is new keyword different from override keyword during inheritance in .NET? | How is String class different from StringBuilder class in .NET? | Illustrate ADO.NET Architecture | Illustrate the importance of Server.Transfer and Response.Redirect in .NET? | Mention the different objects available in Dataset of ADO.NET | Mention the usage of Connection Object in ADO.NET | What are the commonly used methods of Dataadapter in ADO.NET? | What are the different Behavioral Design Patterns that can be used in .NET Architecture? | What are the different Creational Design Patterns that can be used in .NET Architecture? | What are the different Structural Design Patterns that can be used in .NET Architecture? | What are the methods provided by Command Objects in ADO.NET? | What is Internal Access Modifier in C#? |