When I execute the following code:-
SqlConnection connection = new SqlConnection("Server=(local); Integrated
Security=SSPI;Database=Northwind");
Connection.Open();
it appears to create 2 connections instead of 1. I say two connections
because this is what Performance Monitor reports and also the
PerformanceCounter component when the Category is "SQLServer:General
Statistics" and CounterName is "User Connections". AFAICS this only happens
the first time it is executed. Why is there 2 connections ? What is the
other connection for ?
Thanks.
Nick Carter
|