Scenario: You want to improve the performance of your ADO.NET application. What feature of ADO.NET can you leverage to reduce the overhead of opening and closing database connections?
- Command Timeout
- Connection Pooling
- Data Binding
- DataReader
Connection Pooling in ADO.NET helps in managing and reusing database connections, reducing the overhead of opening and closing connections frequently. It maintains a pool of connections that can be reused, thus improving application performance.
Loading...
Related Quiz
- When binding data to a DropDownList, you typically set the ___________ property to the data field that will be displayed to the user.
- You want to retrieve a single value (e.g., the total number of records) from a SELECT statement. Which ADO.NET method would you use for this purpose?
- Which LINQ operator is used to filter elements in a collection based on a specified condition?
- Which namespace is commonly used for LINQ in C#?
- What is the significance of the "Connection Lifetime" property in connection string settings?