public static void TestInserts(string cnx)
{
using (FBAdoDBHelper dbHelper = new FBAdoDBHelper(cnx))
{
string sql = "insert into SAMPLE_TABLE (FIELD_1,FIELD_2,FIELD_3) values (@FIELD_1,@FIELD_2,@FIELD_3)";
FbParameterList sqlParams = new FbParameterList();
try
{
dbHelper.BeginTransaction();
for (int i = 1; i <= 1000; i++)
{
try
{
sqlParams.Items.Clear();
sqlParams.AddInputParam("@FIELD_1", i);
sqlParams.AddInputParam("@FIELD_2", String.Format("SAMPLE DATA #{0}", i));
sqlParams.AddInputParam("@FIELD_3", DateTime.Now);
dbHelper.ExecuteNonQuery(sql, sqlParams.Items.ToArray());
Console.WriteLine(String.Format("Success: {0}", i));
}
catch (Exception ex)
{
Console.WriteLine(String.Format("Error: {0}", i));
throw ex;
}
}
dbHelper.CommitTransaction();
}
catch (Exception exDB)
{
Console.WriteLine("Error: " + exDB.Message);
dbHelper.RollbackTransaction();
}
}
}
