ADO.NET
The ADO.Net making interaction between application and data base, the application could be VB.Net, C#.Net, etc...and the data base could be SQL Server, oracle and etc... The ADO.Net over the ADO concept. The ADO.Net Architecture fully differ from ADO Architecture, Its based XML conversion. The data's all can be cover into XML format, its making more effect to the database operations.
Disconnected Architecture
The ADO.Net has Disconnected architecture. The process is work with copy of data and update into database at the end of the process. The connection is opened to the request and closed at the end of the request. Its keeps the connection at the limited time period. This concept provide more security to data with minimum system performance.
ADO.Net Properties and Performance
ADO.Net has two major properties, one is Dataset and another one is DataProvider
Dataset - Its fully based on disconnected architecture. Its execute with the local copy of data. Its
work with the copy of data and return data to the main database to store at the end of
dataset request.
Data Provider - Its fully executes in the connected architecture. It has maintaining connection to the
data updating process. Their is various type of provider available. It has been
used to depends the database. for e.g. SQL Data provider, OleDb Data Provider.
Each provider has several components
Connection - Its used to make connection from application to database.
Command - Its used to executes commands (e.g. SQL Queries).
Data Reader - Its used to get data from data source as read only format.
Data Adapter - Its used to executes the updating process.
Command object provides three methods
ExecuteNonQuery - Its used to executes command without return value (e.g. INSERT, UPDATE
DELETE)
ExecuteScalar - Its executes return one value from query
ExecuteReader - Its executes return a result set
Data Adapter provides four properties
These properties represents database commands
SelectCommand
InsertCommand
DeleteCommand
UpdateCommand
When the Update method is called, changes in the DataSet are copied back to the database and the appropriate InsertCommand, DeleteCommand, or UpdateCommand is executed.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|