Dapper 一对多查询 one to many

最新推荐文章于 2025-08-24 12:03:41 发布

原创

最新推荐文章于 2025-08-24 12:03:41 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了使用Dapper进行数据库一对多查询的操作，通过C#代码示例详细展示了如何实现从单一实体到多个关联实体的数据获取。

参考文档:Dapper one to many

Table

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Born { get; set; }
    public Country Residience { get; set; }
    public ICollection<Book> Books { get; set; }
}

public class Country
{
    public int CountryId { get; set; }
    public string CountryName { get; set; }
}

public class Book
{
    public int BookId { get; set; }
    public string BookName { get; set; }
}

C# Code

pulic List<Person> GetPersons(){
 var sql = @"SELECT 1 AS Id, 'Daniel Dennett' AS Name, 1942 AS Born, 1 AS CountryId, 'United States of America' AS CountryName, 1 AS BookId, 'Brainstorms' AS BookName
UNION ALL SELECT 1 AS Id, 'Daniel Dennett' AS Name, 1942 AS Born, 1 AS CountryId, 'United States of America' AS CountryName, 2 AS BookId, 'Elbow Room' AS BookName