Tag Archives: Ado.Net Interview Questions

QuestPond’s Interview Questions & Answers on ADO.NET

What is the use of Command objects? Command object helps to execute SQL statements. Following are the methods provided by command object:- ExecuteNonQuery: – Executes insert, update and delete SQL commands. Returns an Integer indicating the number of rows affected … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

QuestPond’s Interview Questions & Answers on ADO.NET

How is stored procedure different from functions? Function cannot affect the state of the database which means we cannot perform CRUD operation on the database. Stored Procedure can affect the state of the database by using CRUD operations. Store Procedure … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | Leave a comment

QuestPond: Interview Questions and Answers on learning ADO.NET

Explain in detail the fundamental of connection pooling? When a connection is opened first time, a connection pool is created and is based on the exact match of the connection string given to create the connection object. Connection pooling only … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

ADO.NET interview questions: – Explain in detail the fundamental of connection pooling and how to enable/disable connection pooling?

When a connection is opened first time, a connection pool is created and is based on the exact match of the connection string given to create the connection object. Connection pooling only works if the connection string is the same. … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

ADO.NET interview questions: – Explain different ways to implement optimistic locking in ADO.NET?

Following are the ways to implement optimistic locking using ADO.NET:- When we call “Update” method of Data Adapter it handles locking internally. If the Dataset values are not matching with current data in Database, it raises concurrency exception error. We … Continue reading

Posted in .NET and C# training, ADO.NET, ADO.NET interview questions, Csharp interview questions, optimistic locking in ADO.NET, programming interview questions | Tagged , , , , , | Leave a comment

ADO.NET interview questions: – Different ways to implement optimistic locking in ADO.NET.

This is one of the ADO.NET interview questions asked in the interview. Answer this question with the simple steps as follows. Ways to implement optimistic locking using ADO.NET: – When we call “Update” method of Data Adapter it handles locking … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | 1 Comment

ADO.NET interview questions: – State different namespaces provided by .NET for data management?

Following are the namespaces provided by .NET for data management:- System.Data This namespace has the dataset object which helps us to access data in a data source independent manner. System.Data.SqlClient: This namespace has objects which helps us to connect to … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment