Sunday, January 25, 2015
punjabtechnicaluniversity.blogspot.in
The most important section in ADO.NET architecture is “Data Provider”.Data Provider provides access to datasource (SQL SERVER , ACCESS ,ORACLE).In short it provides object to achieve functionalities like opening and closing connection , retrieve data and update data.In the below figure you can see the four main sections of a data provider :-
1.Connection.
2.Command object (This is the responsible object to use stored procedures)
3.Data Adapter (This object acts as a bridge between datastore and dataset).
“DataView” object is used to sort and filter data in Datatable.
The most important section in ADO.NET architecture is “Data Provider”.Data Provider provides access to datasource (SQL SERVER , ACCESS ,ORACLE).In short it provides object to achieve functionalities like opening and closing connection , retrieve data and update data.In the below figure you can see the four main sections of a data provider :-
1.Connection.
2.Command object (This is the responsible object to use stored procedures)
3.Data Adapter (This object acts as a bridge between datastore and dataset).
4.Datareader (This object reads data from data store in forward only mode). Dataset object represents disconnected and cached data.If you see the diagram it is not in direct connection with the data store (SQL SERVER , ORACLE etc) rather it talks withData adapter , who is responsible for filling the dataset.Dataset can have one or more Datatable and relations.
ADO.NET Architecture
“DataView” object is used to sort and filter data in Datatable.
0 comments:
Post a Comment
North India Campus