EntityFramework.Extended 支持 mysql

野性酷女 2023-10-03 02:25 5阅读 0赞

1.安装EntityFramework.Extended 或者 Z.EntityFramework.Plus.EF6（推荐）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p6emlsaQ_size_16_color_FFFFFF_t_70][]

2.更改MyDBContext配置

namespace EntityFrameworkCore
    {
        [DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))]
        public class MyDBContext : DbContext
        {
            public MyDBContext()
                :base("name=Default")
            {
                //新增配置
                Database.SetInitializer<MyDBContext>(null);
            }
            
            //新增配置（Z.EntityFramework.Plus.EF6不需要）
            protected override void OnModelCreating(DbModelBuilder modelBuilder)
            {
                modelBuilder.HasDefaultSchema("");
                base.OnModelCreating(modelBuilder);
            }
    
            public DbSet<User> User { set; get; }
            
            //...................
        }
    }

3.Global.asax中注册扩展

using System;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Web;
    using System.Web.Http;
    using System.Web.Mvc;
    using System.Web.Optimization;
    using System.Web.Routing;
    
    namespace YFAPICommon
    {
        public class WebApiApplication : System.Web.HttpApplication
        {
            protected void Application_Start()
            {
                AreaRegistration.RegisterAllAreas();
                GlobalConfiguration.Configure(WebApiConfig.Register);
                FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
                RouteConfig.RegisterRoutes(RouteTable.Routes);
                BundleConfig.RegisterBundles(BundleTable.Bundles);
    
                EfExtendedRegister();
            }
    
            //注册扩展（Z.EntityFramework.Plus.EF6不需要）
            private void EfExtendedRegister()
            {
                var container = new EntityFramework.Container();
                EntityFramework.Locator.RegisterDefaults(container);
                container.Register<EntityFramework.Batch.IBatchRunner>(() => new EntityFramework.Batch.MySqlBatchRunner());
                EntityFramework.Locator.SetContainer(container);
            }
        }
    }

4.使用

//注：Delete和Update之后不用再dbContext.SaveChanges();
    
    dbContext.User.Where(u => u.id == 1).Delete();
    
    dbContext.User.Where(u => u.id == 1).Update(u=>new User { nickName="my name"});

//Z.EntityFramework.Plus.EF6
    public object future()
    {
        //三个值在一次SQL查询中获得，提高查询效率
        var query = dbContext.User.Future();
        var datalist = query.ToList();
        int count = query.Count();
        var data = query.FirstOrDefault();
        return new { datalist, count, data };
    }

//FromCache
    QueryCacheManager.ExpireAll();//清空缓存
    dbContext.User.FromCache().ToList();//从缓存读取

文档：

[https://github.com/zzzprojects/EntityFramework.Extended][https_github.com_zzzprojects_EntityFramework.Extended]

[https://entityframework-plus.net/?z=ef-extended][https_entityframework-plus.net_z_ef-extended]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p6emlsaQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20210819160513282.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p6emlsaQ==,size_16,color_FFFFFF,t_70
[https_github.com_zzzprojects_EntityFramework.Extended]: https://github.com/zzzprojects/EntityFramework.Extended
[https_entityframework-plus.net_z_ef-extended]: https://entityframework-plus.net/?z=ef-extended