日本免费高清视频-国产福利视频导航-黄色在线播放国产-天天操天天操天天操天天操|www.shdianci.com

學(xué)無(wú)先后，達(dá)者為師

網(wǎng)站首頁(yè) 編程語(yǔ)言 正文

輕量級(jí)ORM框架Dapper應(yīng)用支持操作函數(shù)和事物_實(shí)用技巧

作者：.NET開發(fā)菜鳥 ? 更新時(shí)間： 2022-05-08 編程語(yǔ)言

dapper除了支持基礎(chǔ)的CURD、存儲(chǔ)過程以外，還支持操作函數(shù)和事物。

dapper操作函數(shù)的代碼如下：

using Dapper;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DapperDemo
{
    public static class OperFunction
    {
        /// 
        /// Dapper滴調(diào)用函數(shù)
        /// 
        public static void ExecuteFunction()
        {
            // 連接字符串
            string strCon = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString;
            // connection對(duì)象
            IDbConnection dbConnection = new SqlConnection(strCon);
            // 定義參數(shù)
            DynamicParameters paras = new DynamicParameters();
            paras.Add("@num1", 34);
            paras.Add("@num2", 456);
            // 返回值
            paras.Add("@sum", 0, DbType.Int32, ParameterDirection.ReturnValue);
            string functionName = "fun_test";
            // 執(zhí)行
            int count = dbConnection.Execute(functionName, paras, null, null, CommandType.StoredProcedure);
            // 獲取輸出參數(shù)的值
            int sum = paras.Get("@sum");
            Console.WriteLine("sum:" + sum);//輸出390
        }
    }
}

dapper支持事物的代碼如下：

using Dapper;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DapperDemo
{
    public static class OperTransaction
    {
        /// 
        /// Dapper支持事物
        /// 
        public static void ExecuteTransaction()
        {
            // 連接字符串
            string strCon = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString;
            // connection對(duì)象
            IDbConnection dbConnection = new SqlConnection(strCon);
            string strSQL = "DELETE FROM Student WHERE StudentID=@StudentID";
            DynamicParameters paras = new DynamicParameters();
            paras.Add("@StudentID", 3);
            // 在BeginTransaction之前要打開連接，否則報(bào)錯(cuò)：無(wú)效操作，連接已關(guān)閉
            dbConnection.Open();
            // 開啟事物
            IDbTransaction transaction = dbConnection.BeginTransaction();
            try
            {
                dbConnection.Execute(strSQL, paras, transaction: transaction);
                // 提交事務(wù)
                transaction.Commit();
            }
            catch (Exception ex)
            {
                // 回滾事物
                transaction.Rollback();
            }
        }
    }
}

Dapper除了支持Transaction以外，還支持Transactionscope：

public static void ExecuteTransactionScope()
{
      using (var transactionscope = new TransactionScope(TransactionScopeOption.Required))
      {
            // 連接字符串
            string strCon = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString;
            // connection對(duì)象
            IDbConnection dbConnection = new SqlConnection(strCon);
            string strSQL = "DELETE FROM Student WHERE StudentID=@StudentID";
            DynamicParameters paras = new DynamicParameters();
            paras.Add("@StudentID", 6);
            dbConnection.Open();
            try
            {
                dbConnection.Execute(strSQL, paras);
                transactionscope.Complete();
            }
            catch (Exception ex)
            {
                // 不提交事務(wù)默認(rèn)自動(dòng)回滾
                Console.WriteLine(ex.Message);
            }
      }
}

原文鏈接：https://www.cnblogs.com/dotnet261010/p/9076810.html

欄目分類
最近更新