private DbConnection \_dbconn;
   public DbConnection Dbconn
   \{
       get \{ return \_dbconn; \}
       set \{ \_dbconn = value; \}
   \}

   private DbTransaction \_dbtrans;
   public DbTransaction Dbtrans
   \{
       get \{ return \_dbtrans; \}
       set \{ \_dbtrans = value; \}
   \}

   private DbCommand \_dbcmd;
   public DbCommand Dbcmd
   \{
       get \{ return \_dbcmd; \}
       set \{ \_dbcmd = value; \}
   \}

   private DbCommand \_dbcmd2;
   public DbCommand Dbcmd2
   \{
       get \{ return \_dbcmd2; \}
       set \{ \_dbcmd2 = value; \}
   \}

   public Form1\(\)
   \{
       InitializeComponent\(\);
   \}

   private void button1\_Click\(object sender, EventArgs e\)
   \{
       try
       \{
           Dbpfactory =

           Dbconn\.ConnectionString =

           Dbtrans = Dbconn\.BeginTransaction\(\);

           for \(int i = 0; i < 500000; i\+\+\)
           \{
               Dbcmd = Dbconn\.CreateCommand\(\);
               Dbcmd\.Transaction = Dbtrans;
               Dbcmd\.Connection = Dbconn;
               Dbcmd\.CommandType = CommandType\.Text;

               Dbcmd\.CommandText = "INSERT INTO

               Dbcmd\.Prepare\(\);
               Dbcmd\.ExecuteNonQuery\(\);
               <//Dbcmd.Dispose>\(\);

           \}

           Dbtrans\.Commit\(\);


           Dbconn\.Close\(\);

           MessageBox\.Show\("OK"\);
       \}
       catch \(Exception ex\)
       \{
           MessageBox\.Show\(ex\.Message\);
       \}
   \}