c#-mysql 事务提交

最新推荐文章于 2024-08-05 23:41:24 发布

用户147258369

最新推荐文章于 2024-08-05 23:41:24 发布

阅读量565

点赞数 1

分类专栏：后端等文章标签： MySQL 事务处理 C# 数据库操作异常处理

本文链接：https://blog.csdn.net/hyq_07_27/article/details/125671695

版权

后端等专栏收录该内容

8 篇文章 0 订阅

订阅专栏

 public static Boolean ExecuteMySQLTransaction(List<String> sqlList, string connectStr = null)
        {
            string connectionString = "";
            if (string.IsNullOrEmpty(connectStr))
            {
                connectionString = ConfigHelper.GetConnSettingsValue("mysql");
                connectionString = connectionString.Substring(connectionString.IndexOf(':') + 1);
            }
            else
            {
                connectionString = connectStr;
            }

            
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                MySqlCommand cmd = connection.CreateCommand();
                MySqlTransaction transaction = connection.BeginTransaction();
                cmd.Transaction = transaction;
                try
                {
                    foreach (String sql in sqlList)
                    {
                        cmd.CommandText = sql;
                        cmd.ExecuteNonQuery();
                    }
                    transaction.Commit();
                    return true;
                }
                catch (Exception ex)
                {
                    transaction.Rollback();
                    return false;
                }
            }
        }