ado.net creating a single connection versus relying on connection pooling, my two cents.

Creating a connection object at the start of the process and passing it versus relying on connection pooling and the “using” construct?   This seems to be a hot topic in the adonet newsgroup, I would like to put in my two cents. This post deals with the managed pooler in the SqlClient and the…

2

ADO.NET 2.0 The connection pool and distributed transactions

I am a big fan of pop quiz style blogs like the ones you can find here: http://blogs.msdn.com/brada/ . I am not really sure that there are enough people looking at this blog to make this fun but I am going to give it a try. I will incorporate the answer in the blog at…

2

ADO.NET new for 2.0, Clearing the pool on Server recycle

This blog talks about behavior in the SqlClient and the Oracle managed provider exclusively.   One of the biggest problems with pooling before ado.net 2.0 has to be the fact that we did not know how to handle the pool when the server went down. Let me describe just how ugly this behavior was using…

14