What is Ado.Net
Part 1. What is ADO.Net
How does Ado.Net work .
Ado.Net mainly work on two mode Connected and Disconnected mode.
What is Connected Mode ?
1. Connected mode is faster in performance because it works in read or select data fast .
2. Connected mode can be hold the data of single table.
Ex: DataReader is working in Connected .
What is Disconnected Mode ?
1. where as disconnected mode get slow in speed and performance. because it can insert, update, delete and select data.
2. where as disconnected can hold multiple tables of data.
Ex: DataSet is working in disconnected
What is Data Provider ?
The Data Provider mechanisms for managing connected mode. DataSet class provides for managing data . A data provider contains Connection, Command, DataAdapter, and DataReader objects. These four objects provides the functionality of Data Providers in the ADO.NET.
what is DataSet ?
DataSet provides a disconnected representation of result sets from the Data Source, DataSet provides much greater flexibility when dealing with related Result Sets.
we will discuss next tutorial ..
What is connection()
What is Data Adapter()
What is Data Command()
What is Data Reader()
Part 1. What is ADO.Net
- ADO.Net stands for ActiveX Data Objects.
- which is interact with Data Source such as Sql server, oracle and XML file etc. Ado.net is used to retrieved data, insert, update ,delete the data.
- There are two component Data Providers and DataSet .
ADO.Net Architecture
How does Ado.Net work .
Ado.Net mainly work on two mode Connected and Disconnected mode.
What is Connected Mode ?
1. Connected mode is faster in performance because it works in read or select data fast .
2. Connected mode can be hold the data of single table.
Ex: DataReader is working in Connected .
What is Disconnected Mode ?
1. where as disconnected mode get slow in speed and performance. because it can insert, update, delete and select data.
2. where as disconnected can hold multiple tables of data.
Ex: DataSet is working in disconnected
What is Data Provider ?
The Data Provider mechanisms for managing connected mode. DataSet class provides for managing data . A data provider contains Connection, Command, DataAdapter, and DataReader objects. These four objects provides the functionality of Data Providers in the ADO.NET.
what is DataSet ?
DataSet provides a disconnected representation of result sets from the Data Source, DataSet provides much greater flexibility when dealing with related Result Sets.
we will discuss next tutorial ..
What is connection()
What is Data Adapter()
What is Data Command()
What is Data Reader()