.net实现AOP

最新推荐文章于 2024-09-01 09:25:50 发布

weixin_30396699

最新推荐文章于 2024-09-01 09:25:50 发布

阅读量149

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/slyzly/articles/11388441.html

版权

免费的AOP
nuget安装MrAdvice;

using ArxOne.MrAdvice.Advice;
using System;
using System.Data.Entity;

namespace NBSharp.Core
{
    /// <summary>
    /// ef实现with nolock(备用，已用拦截器实现)
    /// 使用：在方法上加上[ReadUncommitedTransactionScope]即可
    /// </summary>
    [Serializable]
    public class ReadUncommitedTransactionScopeAttribute : Attribute//, IMethodAdvice
    {
        public void Advise(MethodAdviceContext context)
        {DbContext db = (DbContext)NBSharpResolver.Resolve<IUnitOfWork>();
            //第二种实现
            db.Database.ExecuteSqlCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;");//with(nolock)

            context.Proceed();//执行aop标记的方法

//第二种实现
            //https://stackoverflow.com/questions/24684914/get-entity-framework-6-use-nolock-in-its-underneath-select-statements/24699606
            //db.Database.ExecuteSqlCommand("SET TRANSACTION ISOLATION LEVEL READ COMMITTED;");//with(lock)
        }
    }
}

转载于:https://www.cnblogs.com/slyzly/articles/11388441.html