Categories : - Late Binding and Early Binding in C#.Net , Latest Inter View Question and Answer
Define ADO.NET ?
The full form of ADO is ActiveX Data Object.
ADO.NET is one of the component in the Microsoft.NET framework which contains following features to Windows, web and distributed applications.
1. Data Access to the applications from Database in connected (Data reader object) and disconnected (Data set and data table) model.
2. Modify the data in database from application.
What is the namespace in which .NET has the data functionality class?
namespaces provided by .NET for data management:
1. System.Data
This contains the basic objects used for accessing and storing relational data, such as DataSet, DataTable, and DataRelation. Each of these is independent of the type of data source and the way we connect to it.
2 .System.Data.OleDB
It contains the objects that we use to connect to a data source via an OLE-DB provider, such as OleDbConnection, OleDbCommand, etc. These objects inherit from the common base classes, and so have the same properties, methods, and events as the SqlClient equivalents.
3 .System.Data.SqlClient
his contains the objects that we use to connect to a data source via the Tabular Data Stream (TDS) interface of Microsoft SQL Server (only). This can generally provide better performance as it removes some of the intermediate layers required by an OLE-DB connection.
4 .System.XML
This contains the basic objects required to create, read, store, write, and manipulate XML documents according to W3C recommendations.
What are the Benefits of ADO.Net?
Interoperability:
XML Format is one of the best formats for Interoperability.ADO.NET supports to transmit the data using XML format.
Scalability:
ADO.NET works on Dataset that can represent a whole database or even a data table as a disconnected object and thereby eliminates the problem of the constraints of number of databases being connected. In this way scalability is achieved.
Performance:
The performance in ADO.NET is higher in comparison to ADO that uses COM marshalling.
Programmability:
ADO.Net Data components in Visual studio help to do easy program to connect to the database.
What are the two fundamental objects in ADO.NET?
DataReader and DataSet are the two fundamental objects in ADO.NET.
What are the major difference between classic ADO and ADO.NET?
Some major differences:
1 : - In ADO, we have a Recordset and in ADO.NET we have a DataSet.
2 : -In Recordset, we can only have one table. If we want to accommodate more than one table, we need to do inner join and fill the Recordset. A DataSet can have multiple tables.
3 : -All data is persisted in XML as compared to classic ADO where data is persisted in binary format.
What is the use of a data adapter?
These objects connect one or more Command objects to a DataSet object. They provide logic that would get data from the data store and populates the tables in the DataSet, or pushes the changes in the DataSet back into the data store.
1 : - An OleDbDataAdapter object is used with an OLE-DB provider
2 : - A SqlDataAdapter object uses Tabular Data Services with MS SQL Server.
What are the different steps to access a database through ADO.NET?
The DataSet provides the basis for disconnected storage and manipulation of relational data. We fill it from a data store, work with it while disconnected from that data store, then reconnect and flush changes back to the data store if required.
C#.Net Interview Question and Answer For Freshness and Experience
Define ADO.NET ?
The full form of ADO is ActiveX Data Object.
ADO.NET is one of the component in the Microsoft.NET framework which contains following features to Windows, web and distributed applications.
1. Data Access to the applications from Database in connected (Data reader object) and disconnected (Data set and data table) model.
2. Modify the data in database from application.
What is the namespace in which .NET has the data functionality class?
namespaces provided by .NET for data management:
1. System.Data
This contains the basic objects used for accessing and storing relational data, such as DataSet, DataTable, and DataRelation. Each of these is independent of the type of data source and the way we connect to it.
2 .System.Data.OleDB
It contains the objects that we use to connect to a data source via an OLE-DB provider, such as OleDbConnection, OleDbCommand, etc. These objects inherit from the common base classes, and so have the same properties, methods, and events as the SqlClient equivalents.
3 .System.Data.SqlClient
his contains the objects that we use to connect to a data source via the Tabular Data Stream (TDS) interface of Microsoft SQL Server (only). This can generally provide better performance as it removes some of the intermediate layers required by an OLE-DB connection.
4 .System.XML
This contains the basic objects required to create, read, store, write, and manipulate XML documents according to W3C recommendations.
What are the Benefits of ADO.Net?
Interoperability:
XML Format is one of the best formats for Interoperability.ADO.NET supports to transmit the data using XML format.
Scalability:
ADO.NET works on Dataset that can represent a whole database or even a data table as a disconnected object and thereby eliminates the problem of the constraints of number of databases being connected. In this way scalability is achieved.
Performance:
The performance in ADO.NET is higher in comparison to ADO that uses COM marshalling.
Programmability:
ADO.Net Data components in Visual studio help to do easy program to connect to the database.
What are the two fundamental objects in ADO.NET?
DataReader and DataSet are the two fundamental objects in ADO.NET.
What are the major difference between classic ADO and ADO.NET?
Some major differences:
1 : - In ADO, we have a Recordset and in ADO.NET we have a DataSet.
2 : -In Recordset, we can only have one table. If we want to accommodate more than one table, we need to do inner join and fill the Recordset. A DataSet can have multiple tables.
3 : -All data is persisted in XML as compared to classic ADO where data is persisted in binary format.
What is the use of a data adapter?
These objects connect one or more Command objects to a DataSet object. They provide logic that would get data from the data store and populates the tables in the DataSet, or pushes the changes in the DataSet back into the data store.
1 : - An OleDbDataAdapter object is used with an OLE-DB provider
2 : - A SqlDataAdapter object uses Tabular Data Services with MS SQL Server.
What are the different steps to access a database through ADO.NET?
The DataSet provides the basis for disconnected storage and manipulation of relational data. We fill it from a data store, work with it while disconnected from that data store, then reconnect and flush changes back to the data store if required.
C#.Net Interview Question and Answer For Freshness and Experience
No comments:
Post a Comment