分享一个dapper简单封装

最新推荐文章于 2024-12-01 23:54:40 发布

转载最新推荐文章于 2024-12-01 23:54:40 发布 · 294 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/fangyuan303687320/p/5513813.html

文章标签：

#数据库

本文介绍了一个使用Dapper ORM框架操作MySQL数据库的基础类实现，包括读写分离、执行SQL语句及事务处理等核心功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System;
using System.Data.Common;
using System.Linq;
using Dapper;
using MySql.Data.MySqlClient;

  
public class DapperBase<T> where T:class,new()
    {

        /// <summary>
        /// 读连接
        /// </summary>
        /// <returns></returns>
        public DbConnection GetWriteConnection()
        {
            MySqlConnection connection = new MySqlConnection(WebconfigUtils.GetWriteDbconfig());
            //NpgsqlConnection connection = new NpgsqlConnection(_sqlconnection);
            connection.Open();
            return connection;
        }

        /// <summary>
        /// 读连接
        /// </summary>
        /// <returns></returns>
        public DbConnection GetReadConnection()
        {
            try
            {
                MySqlConnection connection = new MySqlConnection(WebconfigUtils.GetReadDbconfig());
                connection.Open();
                return connection;
            }
            catch (Exception)
            {
                return GetWriteConnection();
            }
        }

        public T ExecuteSql(string sql, object obj)
        {
            using (var connection = GetReadConnection())
            {
                var model =
                    connection.Query<T>(sql, obj)
                        .FirstOrDefault();
                connection.Close();
                return model;
            }
        }

        /// <summary>
        /// 事务执行sql
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="obj"></param>
        /// <returns></returns>
        public int ExecuteTransactionSql(string sql, object obj)
        {
            using (var connection = GetWriteConnection())
            {
                var trans = connection.BeginTransaction();
                var rows =connection.Execute(sql, obj,trans);
                if (rows > 0)
                {
                    trans.Commit();
                }
                else
                {
                    trans.Rollback();
                }
                connection.Close();
                return rows;
            }
        }

    }