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

一、NuGet获取Abp.Dapper

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

二、创建实体Entity

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

 

1. using Abp.Domain.Entities;

2.  

3. namespace PD.Menu

4. {

5.     public class Sys_Menu : Entity  

6.     {

7.         public virtual string Path { get; set; }

8.         public virtual string Name { get; set; }

9.         public virtual string Permission { get; set; }

10.         public virtual string Meta { get; set; }

11.         public virtual string Title { get; set; }

12.         public virtual string Icon { get; set; }

13.         public virtual string Component { get; set; }

14.         public virtual int FatherId { get; set; }

15.         public virtual int LevelType { get; set; }

16.         public virtual int StatusType { get; set; }

17.     }

18. }

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

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

四、EntityFrameworkModule添加依赖

typeof(AbpDapperModule)

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

五、创建服务接口Application

调用默认的IDapperRepository

1. using Abp.Dapper.Repositories;

2. using System;

3. using System.Collections.Generic;

4. using System.Text;

5.  

6. namespace PD.Menu

7. {

8.     public class MenuTestAppService : PDAppServiceBase, IMenuTestAppService

9.     {

10.         private readonly IDapperRepository<Sys_Menu> _Sys_MenuDapperRepository;

11.         public MenuTestAppService(IDapperRepository<Sys_Menu> sys_MenuDapperRepository)

12.         {

13.             _Sys_MenuDapperRepository = sys_MenuDapperRepository;

14.         }

15.  

16.         public void Get()

17.         {

18.             var aa = _Sys_MenuDapperRepository.GetAll();

19.             var bb = _Sys_MenuDapperRepository.Query("select * from Sys_Menu");

20.         }

21.     }

22. }

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