首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >Dapper关联查询

Dapper关联查询

作者头像
guokun
发布2020-09-03 15:41:55
9780
发布2020-09-03 15:41:55
举报
文章被收录于专栏:销声匿迹销声匿迹

1、一对一:

  using (IDbConnection connecton = new MySqlConnection(ConfigurationManager.ConnectionStrings["default"].ConnectionString))
            {
                string sql = @"SELECT *
                               from expand_userbasicinformation b
                               JOIN expand_users u on b.UserId = u.UserId";
                var infos = connecton.Query<UserInfo, User, UserInfo>(sql, (info, user) =>
                {
                    info.User = user;
                    return info;
                }, splitOn: "UserId");
            }

其中,实体定义如下:

  public class UserInfo
    {
        public string InformationId { get; set; }

        public string UserId { get; set; }

        public User User { get; set; }

        public string RealName { get; set; }
    }

    public class User
    {
        public string UserId { get; set; }

        public string LoginName { get; set; }

        public string LoginPassword { get; set; }
    }

2、一对多:

using (IDbConnection connecton = new MySqlConnection(ConfigurationManager.ConnectionStrings["crmcontroller"].ConnectionString))
            {
                List<Client> clients = new List<Client>();
                string sql = @"SELECT *
                               from crm_client_list
                               join crm_client_field_value on ClientId = ModelId";
                var infos = connecton.Query<Client, ClientField, Client>(sql, (c, f) =>
                {
                    var currentClient = clients.Find(x => x.ClientId == c.ClientId);
                    if (currentClient == null)
                    {
                        c.Fields.Add(f);
                        clients.Add(c);
                        return c;
                    }
                    else
                    {
                        currentClient.Fields.Add(f);
                        return currentClient;
                    }
                }, splitOn: "ModelId");
            }

其中,实体定义如下:

  public class Client
    {
        public Client()
        {
            this.Fields = new List<ClientField>();
        }

        public string ClientId { get; set; }

        public string Name { get; set; }

        public string PhoneNumber { get; set; }

        public string IDNumber { get; set; }

        public List<ClientField> Fields { get; private set; }
    }

    public class ClientField
    {
        public string FieldValueId { get; set; }

        public string ModelId { get; set; }

        public string FieldId { get; set; }

        public string FieldValue { get; set; }
    }
本文参与 腾讯云自媒体分享计划,分享自作者个人站点/博客。
原始发表:2016-09-05 ,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体分享计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档