protected bool Equals(MessageExecuteSetting other)
{
return(string.Equals(DataBaseInstance, other.DataBaseInstance) &&
string.Equals(Connection, other.Connection) &&
IsolationLevel.Equals(other.IsolationLevel));
}
static void Main(string[] args)
{
SqlConnectionStringBuilder cs = new SqlConnectionStringBuilder();
try
{
readConfigFile();
cs.DataSource = strDBServer;
cs.InitialCatalog = strDBInitialCatalog;
cs.ApplicationName = strApplicationName;
cs.IntegratedSecurity = true;
cs.AsynchronousProcessing = true;
string connectionString = cs.ToString();
stopWatch = new Stopwatch();
stopWatch.Start();
SqlConnection connCleanDB = new SqlConnection(connectionString);
connCleanDB.Open();
SqlCommand cmdCleanTable = new SqlCommand(sqlCleanTable, connCleanDB);
cmdCleanTable.CommandType = System.Data.CommandType.StoredProcedure;
cmdCleanTable.ExecuteNonQuery();
connCleanDB.Close();
localDateStarted = DateTime.Now;
for (int i = 1; i <= iNumberofIterations; i++)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = new SqlCommand(sqlAddData, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@method", System.Data.SqlDbType.Int).Value = iMethod;
cmd.Parameters.Add("@id", System.Data.SqlDbType.Int).Value = i / 10;
if (iTransactionIsolation.Equals(TransactionIsolationLiteral.Unspecified))
{
cmd.BeginExecuteNonQuery(new AsyncCallback(EndExecution), cmd);
}
else
{
using (new TransactionScope(TransactionScopeOption.RequiresNew, new TransactionOptions {
IsolationLevel = iTransactionIsolation
}))
{
cmd.BeginExecuteNonQuery(new AsyncCallback(EndExecution), cmd);
}
}
}
/*
* Wait on all threads to complete
*/
while (iNumberofIterationsAttempted < iNumberofIterations)
{
Thread.Yield();
}
localDateCompleted = DateTime.Now;
stopWatch.Stop();
// Get the elapsed time as a TimeSpan value.
ts = stopWatch.Elapsed;
summarize(
connectionString
, ts
);
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}