public void ConnectDisconnectManyTimes()
{
String connectionString = TestSettings.DefaultConnectionString + "Initial Catalog=MASTER;";
m_SqlUtils = new SqlUtils(m_ProviderFactory, connectionString, connectionString, 1);
try
{
for (int i = 0; i < 1000; i++)
{
DbConnection connection = m_SqlUtils.CreateConnection(false);
try
{
}
catch (System.Exception ex)
{
// Process or log errors here.
Console.WriteLine(ex);
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
}
finally
{
m_SqlUtils.Dispose();
m_SqlUtils = null;
}
}
public void ExecuteQueryManyTimes()
{
String connectionString = TestSettings.DefaultConnectionString + "Initial Catalog=MASTER;";
m_SqlUtils = new SqlUtils(m_ProviderFactory, connectionString, connectionString, 1);
try
{
for (int i = 0; i < 1000; i++)
{
DbDataReader reader = null;
try
{
DbCommand sqlCommand = m_ProviderFactory.CreateCommand();
String commandText = @"SELECT * FROM sys.syslogins;";
sqlCommand.CommandText = commandText;
reader = m_SqlUtils.ExecuteReaderWithRetry(sqlCommand);
}
catch (System.Exception ex)
{
Console.WriteLine("Error: " + ex.ToString());
}
finally
{
reader.Close();
}
}
}
finally
{
m_SqlUtils.Dispose();
m_SqlUtils = null;
}
}
public void ExecuteScalarManyTimes()
{
String connectionString = TestSettings.DefaultConnectionString + "Initial Catalog=MASTER;";
m_SqlUtils = new SqlUtils(m_ProviderFactory, connectionString, connectionString, 1);
try
{
for (int i = 0; i < 1000; i++)
{
try
{
DbCommand sqlCommand = m_ProviderFactory.CreateCommand();
String commandText = @"IF EXISTS(SELECT * FROM sys.databases WHERE name = N'MASTER') SELECT 1 AS EXTANT ELSE SELECT 0 AS EXTANT;";
sqlCommand.CommandText = commandText;
int result = (int)m_SqlUtils.ExecuteScalarWithRetry(sqlCommand);
Assert.AreEqual(1, result);
}
catch (System.Exception ex)
{
Console.WriteLine("Error: " + ex.ToString());
}
}
}
finally
{
m_SqlUtils.Dispose();
m_SqlUtils = null;
}
}
public void MyTestCleanup()
{
if (m_SqlUtils != null)
{
m_SqlUtils.Dispose();
}
SqlConnection.ClearAllPools();
}
