一、NuGet获取Abp.Dapper
项目类库Application和项目类库EntityFrameworkCore添加Abp.Dapper引用,如图:
二、创建实体Entity
项目类库Core创建实体,如图:
-
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中为实体定义数据库集
public virtual DbSet<Menu.Sys_Menu> Sys_Menu { set; get; }
四、EntityFrameworkModule添加依赖
typeof(AbpDapperModule)
DapperExtensions.DapperExtensions.SetMappingAssemblies(new List<Assembly> { typeof(VerifyServiceEntityFrameworkModule).GetAssembly()})
五、创建服务接口Application
调用默认的IDapperRepository
-
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