EntityFramework.Extended 支持 mysql

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

 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://entityframework-plus.net/?z=ef-extended

文章来源: zzzili.blog.csdn.net，作者：清雨小竹，版权归原作者所有，如需转载，请联系作者。

原文链接：zzzili.blog.csdn.net/article/details/119783080