Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Can you give a overview of ADO.NET architecture
Can you give a overview of ADO.NET architecture ?
✍: Guest
The most important section in ADO.NET architecture is gData Providerh. 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
ã Connection.
ã Command object (This is the responsible object to use stored procedures)
ã Data Adapter (This object acts as a bridge between datastore and dataset).
ã 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
with Data adapter, who is responsible for filling the dataset. Dataset can have one or
more Datatable and relations.
“DataView” object is used to sort and filter data in Datatable.
Note:- This is one of the favorite questions in .NET. Just paste the picture in your mind
and during interview try to refer that image.
2007-10-24, 4988👍, 0💬
Popular Posts:
What would you use to compare two String variables - the operator == or the method equals()? You can...
Managed Code and Unmanaged Code related ASP.NET - How do you hide Public .NET Classes and other publ...
How to create a thread in a program? You have two ways to do so. First, making your class "extends" ...
How will you freeze the requirement in this case? What will be your requirement satisfaction criteri...
What is ISO? ISO 9000 is a family of standards for quality management systems. ISO 9000 is maintaine...