Data Accessing Technology (ADO.NET)

Data Accessing Technology (ADO.NET)

ADO.NET ( ActiveX Data Object.NET)

Download PDF File

Component corps software the can be used by programmer for the data access of and data services.

Is part of Class library which is figured in with Microsoft.Net Framework

Commonly use to access and modify the on file data in Relational Database Systems, but can use also to access the non relational data source

Is evolution of technology ADO, but his change many and big, is so that considered to be by the new product.

Architecture ADO.NET consist of 2 punch line

  1. Data Provider

Provided access to data source be like : Ms. SQL SERVER or Oracle and OLEDB data provider

  1. Data Sets

Group of classes depict relational simple database in memory

Data Provider have a group of utility :

  • Connection : provide connection to communicate with the data source

  • Command : used to operate [at] data source be like reading, update, and deleting relational data

  • Parameter : formulate single parameter [at] Command. Example [of] : parameter [at] stored procedure

  • Data Adapter : Bridge for the delivery of data [among/between] data source and data object set

  • Data Reader : efficient [of] process of big result, one record in one time, provide record accessed in mode read-only, forward-only

Classes Data Set have the hierarchy :

  • Dataset : present Schema
    • DataTable
      • DataView
        • DataCoulomn : column information
        • DataRow : line information in tables
        • DataRowView : line information [at] DataView
      • DataRelation : relationship between tables
      • Constraint : formulate property Database

Label:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)