public NumOfDBConnections GetNumOfOpenConnection(DBConnectionInfo dbConnectionInfo)
{
NumOfDBConnections numOfConnectionsItem = new NumOfDBConnections();
string masterDBName;
using (var dbCommands = _dbCommandsFactory.CreateDBCommand(dbConnectionInfo))
{
masterDBName = dbCommands.DataBaseName;
}
using (var dbCommands = _dbCommandsFactory.CreateDBCommand(dbConnectionInfo))
{
numOfConnectionsItem.DBName = dbCommands.DataBaseName;
}
using (var dbQueryStatus = _dbCommandsFactory.CreateDBQueryStatus(dbConnectionInfo))
{
numOfConnectionsItem.NumOfConnectionsToDB = dbQueryStatus.GetNumOfOpenConnection(numOfConnectionsItem.DBName);
numOfConnectionsItem.NumOfConnectionsToAdminDB = dbQueryStatus.GetNumOfOpenConnection(masterDBName);
}
return(numOfConnectionsItem);
}
public void AssertNumOfOpenDBConnection(string testName, DBConnectionInfo dbConnectionInfo, NumOfDBConnections numOfOpenConnections_Before)
{
NumOfDBConnections numOfOpenConnections_After = _dbHandler.GetNumOfOpenConnection(dbConnectionInfo);
Assert.That(numOfOpenConnections_Before.NumOfConnectionsToDB, Is.GreaterThanOrEqualTo(numOfOpenConnections_After.NumOfConnectionsToDB), $"{testName} >>> NumOfConnectionsToDB after '{numOfOpenConnections_After.NumOfConnectionsToDB}', is grater then before '{numOfOpenConnections_Before.NumOfConnectionsToDB}'");
Assert.That(numOfOpenConnections_Before.NumOfConnectionsToAdminDB, Is.GreaterThanOrEqualTo(numOfOpenConnections_After.NumOfConnectionsToAdminDB), $"{testName} >>> NumOfConnectionsToAdminDB after '{numOfOpenConnections_After.NumOfConnectionsToAdminDB}', is grater then before '{numOfOpenConnections_Before.NumOfConnectionsToAdminDB}'");
}
