1 / 11

Ado architecture

Ado.net architecture. There are two main components in Ado. Net The .Net Data Provider The Dataset . The .Net Data Provider act as a bridge between the application and the data source to execute commands and retrieve result. 1) Connection Object 2)Command Object 3) DataReader Object

udell
Download Presentation

Ado architecture

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ado.net architecture

  2. There are two main components in Ado. Net • The .Net Data Provider • The Dataset

  3. The .Net Data Provider act as a bridge between the application and the data source to execute commands and retrieve result. • 1) Connection Object • 2)Command Object • 3) DataReader Object • 4)DataAdapter Object

  4. 1)Connection Object • It is useful to make a connection between your application and database • Method : • 1) Open() • 2)Close() • 3)Dispose()

  5. Connection String provides information like data provider, data source, database name, Integrated Security and so on.For instance, • Provider=Providername like oracle oledb • Data Source=SqlServer path • Initial Catalog= Database Name • Username • Password

  6. 2) Command Object • We can use command object for processing request in the form of command and returning the result of those request from the database. • It also provide the functionality of updating records of the database • Command object works in connected architecture mode.

  7. 3)DataReader • DataReader I useful to Read data in sequential mode. • The whole process is Read-only Process. • DataReader object allows only one row of data to be stored in the memory at any point of time

  8. 4)DataAdapter • DataAdapter is used to Communicate between datasource and dataset • It is used to communicate between both vice versa • Fetch the value from datasouce and asign to DataTable or DataSet and also make Final Changes from DataTable or Dataset to Database

  9. Types of .Net data Provider • System.Data.SQLClient - Contains classes for connecting to Microsoft SQL Server. System.Data.OLEDB - Contains classes for connecting to a data source that has an OLEDB provider. System.Data.Odbc - Contains classes for connecting to a data source that has an ODBC driver. System.Data.OracleClient - Contains classes for connecting to an Oracle database server. 

More Related