Hour 17

Quiz Answers

1: When is a connection pool entry established?
  1. When you open a connection to the database

  2. When you fill a DataSet

  3. When you close a connection to the database

  4. When you read the rows from the DataSet

A1: a. When you open a connection to the database. If there is a matching connection string in the connection pool, it will draw on it. Otherwise, it will create a new one (and establish the minimum pool size entries).
2: True or false: Connection pooling is automatically turned off for .NET.
A2: False. In .NET, connection pooling is on as the default (pooling = "true").
3: What must you do every time in coding to make sure that you and others can take advantage of the connection pool in subsequent processing?
  1. Store it in cache

  2. Record the ...

Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.