using Autofac;

using Autofac.Integration.Mvc;

using System;

using System.Collections.Generic;

using System.Data.Common;

using System.Data.Entity;

using System.Data.Entity.Infrastructure;

using System.Data.Entity.Infrastructure.DependencyResolution;

using System.Data.Entity.Infrastructure.Interception;

using System.Data.Entity.SqlServer;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using System.Web.Routing;

using WebApplication3.Models;

namespace WebApplication3

{

    public class MvcApplication : System.Web.HttpApplication

    {

        protected void Application_Start()

        {

            var builder = new ContainerBuilder();

            builder.RegisterControllers(typeof(MvcApplication).Assembly);

            builder.Register<UserContext>((_) => new UserContext());

            builder.Register<IDbInterceptor>((_) => new MyNLogInterceptor());

            builder.Register<Func<IDbExecutionStrategy>>((_) => () => new SqlAzureExecutionStrategy());

            builder.Register<Func<TransactionHandler>>((_) => () => new CommitFailureHandler());

            var container = builder.Build();

            DependencyResolver.SetResolver(new AutofacDependencyResolver(container));

            //添加一个依赖关系解析

            DbConfiguration.Loaded += (s, e) =>

                e.AddDependencyResolver(new MyAutofacDependencyResolver(container), overrideConfigFile: false);

            AreaRegistration.RegisterAllAreas();

            RouteConfig.RegisterRoutes(RouteTable.Routes);

        }

    }

    public class MyNLogInterceptor : IDbCommandInterceptor

    {

        private static NLog.Logger logger = NLog.LogManager.GetCurrentClassLogger();

        public void NonQueryExecuting(DbCommand command, DbCommandInterceptionContext<int> interceptionContext)

        {

        }

        public void NonQueryExecuted(DbCommand command, DbCommandInterceptionContext<int> interceptionContext)

        {

            LogCommandComplete(command, interceptionContext);

        }

        public void ReaderExecuting(DbCommand command, DbCommandInterceptionContext<DbDataReader> interceptionContext)

        {

        }

        public void ReaderExecuted(DbCommand command, DbCommandInterceptionContext<DbDataReader> interceptionContext)

        {

            LogCommandComplete(command, interceptionContext);

        }

        public void ScalarExecuting(DbCommand command, DbCommandInterceptionContext<object> interceptionContext)

        {

        }

        public void ScalarExecuted(DbCommand command, DbCommandInterceptionContext<object> interceptionContext)

        {

            LogCommandComplete(command, interceptionContext);

        }

        private void LogCommandComplete<TResult>(DbCommand command, DbCommandInterceptionContext<TResult> interceptionContext)

        {

            if (interceptionContext.Exception == null)

            {

                logger.Trace("Command completed with result {0}", interceptionContext.Result);

                logger.Trace(command.CommandText);

            }

            else

            {

                logger.WarnException("Command failed", interceptionContext.Exception);

                logger.Trace(command.CommandText);

            }

        }

    }

    public class MyAutofacDependencyResolver : IDbDependencyResolver

    {

        private ILifetimeScope container;

        public MyAutofacDependencyResolver(ILifetimeScope container)

        {

            this.container = container;

        }

        public object GetService(Type type, object key)

        {

            if (container.IsRegistered(type))

            {

                return container.Resolve(type);

            }

            return null;

        }

        public IEnumerable<object> GetServices(Type type, object key)

        {

            if (container.IsRegistered(type))

            {

                return new object[] { container.Resolve(type) };

            }

            return Enumerable.Empty<object>();

        }

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using WebApplication3.Models;

namespace WebApplication3.Controllers

{

    public class HomeController : Controller

    {

        public UserContext Ucontext;

        public HomeController(UserContext context)

        {

            this.Ucontext = context;

        }

        // GET: Home

        public ActionResult Index()

        {

            User user = new User { Name = "", Pwd = "" };

            Ucontext.Users.Add(user);

            Ucontext.SaveChanges();

            return Content("Yes");

        }

        protected override void Dispose(bool disposing)

        {

            if (disposing)

            {

                Ucontext.Dispose();

            }

            base.Dispose(disposing);

        }

    }

}