What are the pre-requisites for connection pooling? | .NET QUESTIONS ANSWERS

There must be multiple processes to share the same connection describing the same parameters and security settings. The connection string must be identical.

Name the method that needs to be invoked on the DataAdapter control to fill the generated DataSet with data? | .NET QUESTIONS ANSWERS

The Fill() method is used to fill the dataset with data.

Which property is used to check whether a DataReader is closed or opened? | .NET QUESTIONS ANSWERS

The IsClosed property is used to check whether a DataReader is closed or opened. This property returns a true value if a Data Reader is closed, otherwise a false value is returned.

What is the role of the DataSet object in ADO.NET? | .NET QUESTIONS ANSWERS

One of the major component of ADO.NET is the DataSet object, which always remains disconnected from the database and reduces the load on the database.

Which architecture does Datasets follow? | .NET QUESTIONS ANSWERS

Datasets follow the disconnected data architecture.

Mention the namespace that is used to include .NET Data Provider for SQL server in .NET code | .NET QUESTIONS ANSWERS

The System.Data.SqlClient namespace.

What is the meaning of object pooling? | .NET QUESTIONS ANSWERS

Object pooling is a concept of storing a pool (group) of objects in memory that can be reused later as needed. Whenever, a new object is required to create, an object from the pool can be allocated for this request; thereby, minimizing the object creation. A pool can also refer to a group of connections and threads. Pooling, therefore, helps in minimizing the use of system resources, improves system scalability, and performance.