ADO.NET interview questions

ADO.NET interview questions with answers

<<Previous  Next>>

ADO.NET overview ADO.NET is design to provide data access. ADO.NET supports disconnected database access model which means that connection is open long enough to perform data operation and is closed............. Read answer ADO.NET vs ADO ADO.NET is considered as evolution version of ADO. ADO.NET works with both connected as well as disconnected fashion whereas ADO works with connected architecture............. Read answer ADO.NET Data Architecture ADO.NET has four layers. The Physical Data Store This can be any database, XML files or OLE................ Read answer Type of database connection in ADO.NET SQL Connection This object connects to the SQL Server.............. Read answer Components of data providers in ADO.NET The Connection Object The Connection object represents the connection to the database. The Connection object has ConnectionString property that contains all the information.............. Read answer Define connected and disconnected data access in ADO.NET You have connected data access through the DataReader objects of data provider. This object requires exclusive use of the connection object. It can provide fast and forward-only data access. It doesn't allow editing................... Read answer Describe CommandType property of a SQLCommand in ADO.NET. A SQLCommand has CommandType property which can take Text, Storedprocedure or TableObject as value. If it is set to Text, the command executes SQL string that is set to CommandText property................ Read answer Define Dataview component of ADO.NET. A DataView object allows you work with data of DataTable of DataSet object. It is associated with a DataTable and sits on the top of DataTable.............. Read answer What are the ways to create connection in ADO.NET? There are two ways to create connection supported by ADO.NET. Steps to create connection in code Create instance of connection object.............. Read answer Access database at runtime using ADO.NET Steps to connect to database Declare and initialize database connection object with appropriate connection string. Create a DataAdapter and a Dataset object.............. Read answer ADO.NET Code showing Dataset storing multiple tables Declare and initialize database connection object with appropriate connection string. Create a DataAdapter and a Dataset object............ Read answer ADO.NET Code executing stored procedure Code showing how to fetch data using Stored Procedure. Imports System Imports System.Data Imports System.Data.SqlClient............ Read answer ADO.NET transaction Processing Steps to use transaction object  Open a database connection. Create the transaction object using BeginTransaction method of connection object............... Read answer <<Previous  Next>> ADO.NET Interview questions to be prepared before Interview. Provide the namespaces for ADO.NET. Brief about an overview of ADO.NET architecture. List out difference between Dataset and ADO Recordset. List out difference between classic ADO and ADO.NET. Explain connection object in ADO.NET. Explain the methods of command objects. What is dataadapter? What are its methods? What is Dataset object? What are the various objects in Dataset ? How can we connect to Microsoft Access , Foxpro , Oracle etc ? Explain how to check for changes made to dataset. Provide namespace to connect to SQL Server. Explain the steps to use stored proceduce in ADO.NET. How can we force the connection object to close? Is is possible to force datareader to return only schema. How can we optimize command object when there is only one row? What is basic use of “DataView” ? Describe how to fill a dataset. What are the methods provided by the dataset for XML? Explain how to save all data from dataset. How can we add/remove row’s in “DataTable” object of “DataSet” ? What is difference between “DataSet” and “DataReader” ? How can we load multiple tables in a DataSet ? Explain how to add relation’s between table in a DataSet ? What is the use of CommandBuilder? List out difference between “Optimistic” and “Pessimistic” locking. Describe the way to implement locking in ADO.NET. Describe how to use transactions in .NET. List out difference between dataset and datareader. What’s difference between Dataset. clone and Dataset. copy ? Which is the best place to store connectionstring? More questions on ADO.NET What are .NET data providers? What are the ADO.NET classes? Explain them DataReader vs. DataSet. List the advantages of using ADO.NET over classic ADO. Explain how to retrieve and update databases from ADO.NET. How does XML integration go beyond the simple representation of data as XML? Overview of ADO.NET architecture. Data Provider provides objects through which functionalities like opening and closing connection, retrieving and updating data can be availed............. Command objects uses, purposes and their methods. The command objects are used to connect to the Datareader or dataset objects with the help of the following methods......... What is Dataset object? Explain the various objects in Dataset? The DataSet object is a disconnected storage. It is used for manipulation of relational data............. What are the steps involved to fill a dataset? We fill it with data fetched from the data store. Once the work is done with the dataset, connection is reestablished and the changes are reflected back into the store................ Explain the basic use of “DataView” and explain its methods. A DataView is a representation of a full table or a small section of rows, it is used to sort and find data within Datatable. Differences between “DataSet” and “DataReader”. DataSet object can contain multiple rowsets from the same data source as well as from the relationships between them....... ASP.NET Interview questions part 2 includes following questions with answers Define access modifiers. | Name the namespace for Web page in ASP.NET. | Write difference between overloading and overriding. | Write Namespace for user locale in ASP.NET. | How do you implement inheritance in .NET? | Explain the differences between Server-side and Client-side code. | Define ADO.NET Dataset. | Define global.asax in ASP.NET. | What are the Application_Start and Session_Start subroutines used for? | Define inline code and code behind. | What is MSIL? | Name the class Web Forms inherit from. ASP.NET 2.0 Administration and Management One of the key goals of ASP.NET 2.0 is to ease the effort required to deploy, manage, and operate ASP.NET web sites. To this end, ASP.NET 2.0 features a new Configuration Management API that enables users to programmatically build programs or scripts that create, read, and update configuration files such as Web.config and machine.config............. ASP.NET 2.0 Speed and Performance As part of the performance improvements, ASP.NET 2.0 also enhances the caching feature set by providing new functionalities........... ASP.NET 2.0 Caching Feature Caching is defined as temporary storage of data for faster retrieval on subsequent requests. In ASP .NET 2.0, the caching support is integrated with the DataSource controls to cache data in a web page. ASP.NET 2.0 also now includes automatic database server cache invalidation............ Understanding AJAX AJAX is an acronym for Asynchronous JavaScript and XML. If you think it doesn't say much, we agree. Simply put, AJAX can be read "empowered JavaScript", because it essentially offers a technique for client-side JavaScript to make background server calls and retrieve additional data as needed, updating certain portions of the page without causing full page reloads............. ASP.NET 2.0 Validation Groups With ASP.NET 2.0, Microsoft introduces a new feature known as validation groups, which enables you to create different groups of validation controls and assign them to input controls, such as text boxes. You can assign a validation group to a collection of input controls if you want to validate the collection of input controls on the same criteria............ ASP.NET 2.0 Themes One of the neat features of ASP.NET 2.0 is themes, which enable you to define the appearance of a set of controls once and apply the appearance to your entire web application............