Protect you computer and your data


 

ftxonline.com keyword stats



Most current MSN search phrases:

file extension lnk  

Dot Net - Connection Pooling

The connection string representing an openfor applications that are in constant
and unique link to a data source. Where acommunication with a database by negating the
distributed system is held, this involves aneed to re-open connections. Some database
network connection. This connection Dependsadministrators may frown on the practice
on the data source, the programming interfacesince multiple connections to the database
of the various connection objects may beare open. Using connection pooling depends
different depends upon which they are buildupon available server resources and
on. A connection object is specific to aapplication requirements (i.e., does it
particular type of data source, such as it isreally  need  it).
different for SQL Server and Oracle and
Microsoft Access. Connection objects are notUsing connection pooling - Dot Net Interview
used interchangeably across different dataQuestions
sources, but all the methods and properties
grouped  in  the  IDb  Connection  interface.Connection pooling is enabled by default. You
may override the default behavior with the
In ADO NET, connection objects arepooling setting in the connection string. The
implemented within data providers as sealedfollowing SQL Server connection string does
classes. So a connection class can never benot  utilize  connection  pooling:
modified or overridden, it is just configured
through properties and attributes. We can sayData Source=TestServer;Initial
that in Ado net all the connection classesCatalog=Northwind;
support connection pooling, although each
class may implement in different manner.User
Connection pooling is implicit, so no need toID=Chester;Password=Tester;Pooling=False;
do manually because it provider manages this
automatically.• Max Pool Size: The maximum number of
connections allowed in the pool. The default
ADO NET pools connections with the samevalue  is  100.
connection or configuration. We can maintain
more than one pool, one for each• Min Pool Size: The minimum number of
configuration. An interesting note:connections allowed in the pool. The default
Connection pooling is utilized by defaultvalue  is  zero.
otherwise specified. If we close and dispose
of all connections, then there will be no• Enlist: Signals whether the Pooler
pool  left  in  connection  pooling.automatically enlists the connection in the
creation thread's current transaction
If we take database connections continuouslycontext. The default value is true.
open can be troublesome, it can be help full



1 A B C 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 96 97 98 99 100 101 102 103 104 105