C#利用显示声明数据库事务完成快速存储

显示声明事务后读写速度有了大幅度提升。

public static void ExecuteSql()        {            using (SQLiteConnection sqliteConn = new SQLiteConnection("连接字符串"))            {                sqliteConn.Open();                ///显示开启一个事务                using (DbTransaction dbTrans = sqliteConn.BeginTransaction())                {                    using (DbCommand cmd = sqliteConn.CreateCommand())                    {                        try                        {                            for (int i = 0; i < 10000; i++)                            {                                cmd.CommandText = string.Format("INSERT INTO " + "表名" + " ( value )VALUES('{0}')", i);                                cmd.ExecuteNonQuery();                            }                            ///提交事务                            dbTrans.Commit();                        }                        catch                        {                            ///回滚事务                            dbTrans.Rollback();                        }                    }                }            }        }