37 important interview questions on ADO.NET

37 important interview questions onADO.NET

This section will cover the most asked questions related to
ADO.NET during .net interview by the interviewer so have a look on the following and do revise it when ever you go for the ADO.NET

Normally the .net interviewer starts with…..

What is the namespace in which .NET has the data functionality class?

Can you give an overview of ADO.NET architecture?

What are the two fundamental objects in ADO.NET?

What is difference between dataset and data reader?

What are major difference between classic ADO and ADO.NET?

What is the use of connection object?

What is the use of command objects?

What is the use of data adapter?

What are basic methods of Data adapter?

What is Dataset object?

What are the various objects in Dataset?

How can we connect to Microsoft Access, FoxPro, and Oracle etc?

How do we connect to SQL SERVER, which namespace do we use?

How do we use stored procedure in ADO.NET and How do we provide parameters to the stored procedures?

How can we force the connection object to close after my data reader is closed?

I want to force the data reader to return only schema of the data store rather than data.

How can we fine-tune the command object when we are expecting a single row?

Which is the best place to store connection string in .NET projects?

What are the steps involved to fill a dataset?

What are the various methods provided by the dataset object to generate XML?

How can we save all data from dataset?

How can we check that some changes have been made to dataset since it was loaded?

How can we add/remove row is in “Data Table” object of “Dataset”?

What is basic use of “Data View”?

What is the difference between “Dataset” and “Data Reader”?

How can we load multiple tables in a Dataset?

How can we add relation between tables in a Dataset?

What is the use of Command Builder?

What’s difference between “Optimistic” and “Pessimistic” locking?

How many ways are there to implement locking in ADO.NET?

How can we perform transactions in .NET?

What is difference between Dataset Clone and Dataset. Copy?

Can you explain the difference between an ADO.NET Dataset and an ADO Record set?

Explain in detail the fundamental of connection pooling?

What is Maximum Pool Size in ADO.NET Connection String?

How to enable and disable connection pooling?

What extra features does ADO.Net 2.0 have?

So friends answering to above questions on ADO.NET helped me to clear interview in front of the interviewer.


About c# and .NET Interview questions

This blog is for developers who want to crack .NET and C# interviews. It has all tips and tricks needed to crack .NET interviews , C# interview , SQL Server interview , Java interview , WCF Interview , Silverlight interview , WPF interview , LINQ interview , Entity framework Interview. Do not forget to watch our Learn step by step video series. Learn MVC in 16 hours:- https://www.youtube.com/watch?v=Lp7nSImO5vk Learn AngularJS Step by Step:- https://www.youtube.com/watch?v=0kmdjqgO9IY Learn Design Pattern in 8 hours:- https://www.youtube.com/watch?v=YDobmucohqk Learn C# and .NET in 60 days:- https://www.youtube.com/watch?v=yh2SrzCkNQA Learn MSBI in 32 hours:- https://www.youtube.com/watch?v=mGPJx3ocFgg Learn SharePoint Step by Step in 8 hours:- https://youtu.be/C2fW76SwJNU
This entry was posted in Uncategorized and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s