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 anIf we take database connections
open and unique link to a data source.continuously open can be troublesome, it
Where a distributed system is held, thiscan be help full for applications that
involves a network connection. Thisare in constant communication with a
connection Depends on the data source,database by negating the need to re-open
the programming interface of the variousconnections. Some database
connection objects may be differentadministrators may frown on the practice
depends upon which they are build on. Asince multiple connections to the
connection object is specific to adatabase are open. Using connection
particular type of data source, such aspooling depends upon available server
it is different for SQL Server andresources and application requirements
Oracle and Microsoft Access. Connection(i.e., does it really need it).
objects are not used interchangeablyUsing connection pooling - Dot Net
across different data sources, but allInterview Questions
the methods and properties grouped inConnection pooling is enabled by
the IDb Connection interface.default. You may override the default
In ADO NET, connection objects arebehavior with the pooling setting in the
implemented within data providers asconnection string. The following SQL
sealed classes. So a connection classServer connection string does not
can never be modified or overridden, itutilize connection pooling:
is just configured through propertiesData Source=TestServer;Initial
and attributes. We can say that in AdoCatalog=Northwind;
net all the connection classes supportUser
connection pooling, although each classID=Chester;Password=Tester;Pooling=False
may implement in different manner.;
Connection pooling is implicit, so no• Max Pool Size: The maximum number of
need to do manually because it providerconnections allowed in the pool. The
manages this automatically.default value is 100.
ADO NET pools connections with the same• Min Pool Size: The minimum number of
connection or configuration. We canconnections allowed in the pool. The
maintain more than one pool, one fordefault value is zero.
each configuration. An interesting note:• Enlist: Signals whether the Pooler
Connection pooling is utilized byautomatically enlists the connection in
default otherwise specified. If we closethe creation thread's current
and dispose of all connections, thentransaction context. The default value
there will be no pool left in connectionis true.
pooling.



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 95 96 97 98 99 100 101 102 103 104 105