![connecting dot by dot interview questions connecting dot by dot interview questions](https://4.bp.blogspot.com/-GaP9Hu7nP_M/WJlaQTOMPpI/AAAAAAAAAes/GhStzePqDrEY30NdeexMdxQjhCDNcFO0ACLcB/s1600/Routing.jpg)
Scope of a connection object can be local or global. Once connection is established, SQL Commands like insert, update, delete and select can be executed. It also support querying.Īlso Read - ASP.Net MVC Interview Questions and AnswersĨ) What is the use of connection object ?Ĭonnection Objects is used to establish a connection between an application and databases like Oracle, MySQl, SQL Server etc. But user can do transactions using DataSet. Dataset takes lot of application memory compared to DataReader. Since it support forward only data iteration, random data fetch is not supported.ĭataSet is an in-memory representation of a table in a database. In Recordset if we want to have more table data we need to perform inner join whereas DataSet can have multiple table data. The major differences between classic ADO and ADO.NET as below: ADO has Recordset whereas ADO.NET has DataSet. Since DataReader is read only, transactions are not allowed. Answer: This is the advanced ADO.NET Interview Questions asked in an interview. Since the rows are fetched one at a time, load on the network will be low. DataReader is used to read the read only data from a database.Īlso Read - ASP.Net Interview Questions and Answersħ) What is difference between dataset and datareader ?ĭataReader is used to fetch data from a database in a much faster way. DataSet can be used in disconnected connection with DB. DataSet Object can have a set of DataTables and relationships between these tables. Must Read - SQL Query Interview Questions and AnswersĦ) What are the two fundamental objects in ADO.NET ?įundamental Objects of ADO.Net are DataReader and DataSet. What are two important objects of ADO.Net There are two important objects of ADO. ADO.Net framework has set of classes which are used to handle data access by connecting with different databases like SQL, Access, Oracle, etc 2. ADO.Net Support both client side and server side cursors What is an ADO.Net ADO.Net is commonly termed as ActiveX Data Objects which is a part of.By leveraging known meta data at design time, ADO.Net provide better runtime performance and more consistent runtime behaviour.Only Client Side Cursors are allowed in ADO.Since ADO derives information about data implicitly at run time based on metadata, it is an expensive process.ADO supports mostly connection oriented models.– Contains SQL Server data typesĥ) What are major difference between classic ADO and ADO.NET ?.- OLE DB provider classes used to access database such as Oracle, MySQL, SQL Server and MS Access.– Contains classes which are shared / overridden by data providers.System.Data – Contains all generic data access classes.4) What are the namespaces used in ADO.NET for data access ?