开发者

Are Ado.net (2.0+) Connection Pools pre Application Domain or per Process

I'm trying to understand the pooling theory w.r.t. to interactions between ADO.NET and SQL Server much better and haven't fou开发者_开发技巧nd the definitive answer. I have always assumed per process but it's just occurred to me that it could be per AppDomain.

Any in depth references would also be appreciated.


Connection pools are a complicated beast in that they are created in several differing scopes. According to SQL Server Connection Pooling on MSDN:

Connections are pooled per process, per application domain, per connection string and when integrated security is used, per Windows identity. Connection strings must also be an exact match; keywords supplied in a different order for the same connection will be pooled separately.

This means that you could have several connection pools within the same application based on how and where the connection is made.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜