C# 事务控制循环插入数据 同一sql语句



public int ExecuteSql(List<string> listsql)        {            OleDbCommand command = null;            try            {                Open();                command.Connection = conn;                command.Transaction = conn.BeginTransaction();                int i=0;                foreach (string sql in listsql)                {                    command.CommandText = sql;                    i += command.ExecuteNonQuery();                }                command.Transaction.Commit();                return i;            }            catch (OleDbException e)            {                command.Transaction.Rollback();                foreach (string sql in listsql)                    log.Error(sql, e);            }            return 0;        }