ADO.NET Interview Questions

What is the difference between data reader & data set

Explain about command builder class feature?

Explain about ADO.NET and its features?

Difference between SqlCommand and SqlCommandBuilder

Explain about Data services?

How do different components of ADO.Net interact with each other in disconnected architecture?

How do I read data (or records) from database using data reader?

How can we load multiple tables in to Dataset?

How many records can take clustured index in sql server

What is the Dot Net Framework data provider for Oracle?

Explain about data provider?

How do I insert records using data reader?

Can we connect two datareader to same data source using single connection at same time?

What is ADO.Net?

What is the difference between data reader and data adapter.

Explain about LINQ?

What are the basic steps involved in data access with ADO.Net in disconnected environment?

What is the difference between ADO and ADO.NET?

How do you get records number from 5 to 15 in a dataset of 100 records? Write code.

Why can't we use Multiple inheritance and garbage collector paralelly in .net

How do I call a stored procedure from my application using ADO.Net?

Explain LINQ to Entities?

What is the advantage of using stored procedure over the SQL queries?

Explain about the command Data reader?

What is the Dot Net Framework data provider for SQL Server?

How do I write common code for different dot net framework data providers?

Explain about the relationship of XML and ADO.NET?

Does SQLClient and OLEdb class share the same functionality

What are the different languages which implement ADO?

How to select data set or data reader?

What are good ADO.NET object(s) to replace the ADO Recordset object?

What does it mean by disconnected data access architecture of ADO.Net?

What is the architecture of connected environment of data access in ADO.Net?
What is a dataset?

What is a connection object in ADO.NET? How to connect to a database in .Net?

What's the difference between accessing data with dataset or data reader?

Type of database connection in ADO.NET

How do I save the changes, made in the dataset, to the database?

On order to get assembly info which namespace we should import?

Compare and explain about ADO.NET and Visual Stuidio.NET?

Why edit is not possible in repeater??

How do I solve the deployment issues (mentioned in the previous FAQ)?

How can I make my first application with DataGrid using the data from ADO.Net?

How can you find a problem in the data stack?

What are the standard dot net framework data providers that are shipped with the Dot Net Framework 1.1?

What is the execution procedure in oracle ?

What does it mean by Dot Net Framework Data Provider?

What is the Dot Net Framework data provider for OLEDB?

What is a Data View in ADO.NET?

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
How to find the given query is optimised one or not?

What is a stored procedure?

Explain the three services model (three-tier application).

How do I update a record in the table using ADO.Net dataset?

How do I make my first ?Hello, Data Access Application Deployment? setup program?

How to copy the contents from one table to another table and how to delete the source table in ado.net?
How do I define a data adapter?

How to copy the contents from one table to another table and how to delete the source table in ado.net?
Explain about Active X data objects?

How XML is supported in ADO.Net?
What are the different row versions available in table?

How do I find the connection string for the database server?

What is a data adapter?

What is a data reader?

What is the role of the DataReader class in ADO.NET connections?

Name some of the top level objects which ADO consists?

What is Partial class?

How do I create a command and supply the SQL query to ADO.Net? (Command object and command string)

What is a database connection?

Why should one use a specialized data provider when the data can be accessed with general data providers?

What is a database command?

Explain ExecuteNonQuery?

What does it mean by connected data access architecture of ADO.Net?

ADO.NET vs ADO

What are the two fundamental objects in ADO.NET?

How do I read records from the data tables?

What is connection String?

How do you declare a static variable and what is its lifetime? Give an example.

State some of the basic steps required to access and manipulate data?

Can dataReader hold data from multiple tables?