Tag Archives: ADO.NET training

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