ado.net 2.0 changes in latest community drop.

Well, it has been a long time since my last blog and it is going to be a while before I get going again. Whenever this happens you can count on me being either insanely behind or on vacation.   I am happy to report that the insanely behind part is over. The ado.net team…

13

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

Design time Side by Side poll (installing different versions of visual studio)

I became involved in the Side by Side and compatibility work items after making the mistake of voicing the fact that I did not like these scenarios. Life can laugh at you that way well enough on it’s own, but in Microsoft a comment like that is like playing with fire. I have grudgingly come…

9

ADO.NET The misunderstood “Connection Lifetime” managed pooler connection string keyword.

I find that we have not done a good job of explaining the “knobs” used to tweak the managed connection pool (the one used by SqlClient and OracleClient), the worst knob definitely has to be the “Connection Lifetime” keyword. First of all, the name is bad. Really really bad. In Whidbey we are renaming it…

17

Sql Server 2005 User Defined Types and the “File or assembly name not found” exception.

“File or assembly name ‘<udtname>’, Version=1.2.0.0, Culture=neutral, PublicKeyToken=389619d4c1235f8a’, or one of its dependencies, was not found.” If you have started using Sql Server 2005 User Defined Types it is likely that you have run into the exception above. Why is this happening? The short answer is that Fusion has not been able to find your…

0

ADO.NET 2.0 Multiple Active Resut Sets per connection in Sql Server 2005 (MARS) FAQ

ADO.NET 2.0 Multiple Active Resut Sets per connection in Sql Server 2005 (MARS) FAQ   Q: What is MARS? A: MARS is a new feature in ado.net 2.0 and Sql Server 2005 that allows for multiple forward only read only result sets. EDIT There is a great article on MARS up at the technet site….

19

ADO.NET 2.0 Asynchronous Command Execution (ASYNC) FAQ

ADO.NET 2.0 Asynchronous Command Execution (ASYNC) FAQ (DISCLAIMER: Based on Whidbey beta1 and subject to change) Before going into the Q&A below I would highly recommend reading Pablo’s excellent Async article located here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/async2.asp Q: What is the new ADO.NET 2.0 Asynchronous Command Execution feature.A: ASYNC allows you to execute a command in a non-blocking…

5

Rhythms Airlift

Yesterday I had the fortune of meeting Bob Beauchemin (http://staff.develop.com/bobb/weblog/)  for the first time. I am a big fan!  I really admire his ability to simplify hard concepts into easy to digest articles and his willingness to roll down his sleeves into some murky undocumented area. One of my favorite examples was this excellent article…

1