O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required