ABP框架—后台：引入Abp.Dapper（10）

柔情只为你懂 2021-10-23 22:56 375阅读 0赞

### 一、NuGet获取Abp.Dapper ###

项目类库Application和项目类库EntityFrameworkCore添加Abp.Dapper引用,如图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70][]

###    二、创建实体Entity ###

项目类库Core创建实体,如图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 1][]

using Abp.Domain.Entities;
    
    namespace PD.Menu
    {
        public class Sys_Menu : Entity  
        {
            public virtual string Path { get; set; }
            public virtual string Name { get; set; }
            public virtual string Permission { get; set; }
            public virtual string Meta { get; set; }
            public virtual string Title { get; set; }
            public virtual string Icon { get; set; }
            public virtual string Component { get; set; }
            public virtual int FatherId { get; set; }
            public virtual int LevelType { get; set; }
            public virtual int StatusType { get; set; }
        }
    }

### 三、DbContext中为实体定义数据库集 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 2][]

public virtual DbSet<Menu.Sys_Menu> Sys_Menu { set; get; }

###    四、EntityFrameworkModule添加依赖 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 3][]

typeof(AbpDapperModule)

DapperExtensions.DapperExtensions.SetMappingAssemblies(new List<Assembly> { typeof(VerifyServiceEntityFrameworkModule).GetAssembly()})

###    五、创建服务接口Application ###

调用默认的IDapperRepository

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 4][]

using Abp.Dapper.Repositories;
    using System;
    using System.Collections.Generic;
    using System.Text;
    
    namespace PD.Menu
    {
        public class MenuTestAppService : PDAppServiceBase, IMenuTestAppService
        {
            private readonly IDapperRepository<Sys_Menu> _Sys_MenuDapperRepository;
            public MenuTestAppService(IDapperRepository<Sys_Menu> sys_MenuDapperRepository)
            {
                _Sys_MenuDapperRepository = sys_MenuDapperRepository;
            }
    
            public void Get()
            {
                var aa = _Sys_MenuDapperRepository.GetAll();
                var bb = _Sys_MenuDapperRepository.Query("select * from Sys_Menu");
            }
        }
    }

说明：ABP官方说明https://aspnetboilerplate.com/Pages/Documents/Dapper-Integration

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 5][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70]: /images/20211023/47c6ab5863184e82a1fa77e25f901db6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 1]: /images/20211023/aa7e8f75f5034c19bce7bb40bb5cd20a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 2]: /images/20211023/70b8a73b66db499186e2f248e7a5647d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 3]: /images/20211023/f26e475185a0442a800a5dcef5928192.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 4]: /images/20211023/d13c4b10ec58476ea23b48657b189710.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzE2OTk4OTQ1_size_16_color_FFFFFF_t_70 5]: /images/20211023/06d33fdcd9b746b5a041114641ad55e5.png