public void TestOpeningConnectionsParallelOnSqlTask()
{
ConnectionManagerHelper.AssertOpenConnectionCount(0, ConnectionStringParameter);
List <int> array = new List <int>()
{
1, 2, 3, 4
};
Parallel.ForEach(array, new ParallelOptions {
MaxDegreeOfParallelism = 2
},
curNr => new SqlTask($"Test statement {curNr}", $@"
DECLARE @counter INT = 0;
CREATE TABLE dbo.test{curNr} (
Col1 nvarchar(50)
)
WHILE @counter <= 10000
BEGIN
SET @counter = @counter + 1;
INSERT INTO dbo.test{curNr}
values('Lorem ipsum Lorem ipsum Lorem ipsum Lorem')
END
")
{
ConnectionManager = new SqlConnectionManager(new ConnectionString(ConnectionStringParameter)),
DisableLogging = true
}.ExecuteNonQuery()
);
ConnectionManagerHelper.AssertOpenConnectionCount(2, ConnectionStringParameter);
SqlConnection.ClearAllPools();
ConnectionManagerHelper.AssertOpenConnectionCount(0, ConnectionStringParameter);
}
public void TestOpeningConnectionTwice()
{
SqlConnectionManager con = new SqlConnectionManager(new ConnectionString(ConnectionStringParameter));
ConnectionManagerHelper.AssertOpenConnectionCount(0, ConnectionStringParameter);
con.Open();
con.Open();
ConnectionManagerHelper.AssertOpenConnectionCount(1, ConnectionStringParameter);
con.Close();
ConnectionManagerHelper.AssertOpenConnectionCount(1, ConnectionStringParameter);
SqlConnection.ClearAllPools();
ConnectionManagerHelper.AssertOpenConnectionCount(0, ConnectionStringParameter);
}
public void TestOpeningCloseConnection()
{
/*User calls Open()
* This first call creates a SqlConnection() object
* It then checks to ensure that it's not open and attempts to open a connection
* User calls Open() again
* This second call creates a new SqlConnection() object
* It then checks to ensure that it's not open, which it is not because its a new one...
*/
SqlConnectionManager con = new SqlConnectionManager(new ConnectionString(ConnectionStringParameter));
ConnectionManagerHelper.AssertOpenConnectionCount(0, ConnectionStringParameter);
con.Open();
ConnectionManagerHelper.AssertOpenConnectionCount(1, ConnectionStringParameter);
con.Close(); //won't close any connection - ado.net will keep the connection open in it's pool in case it's needed again
ConnectionManagerHelper.AssertOpenConnectionCount(1, ConnectionStringParameter);
SqlConnection.ClearAllPools();
ConnectionManagerHelper.AssertOpenConnectionCount(0, ConnectionStringParameter);
}