Dapper 连表查询

实体类：

UserInfo:

public partial class UserInfo
    {
        public UserInfo()
        {
            this.Persion = new HashSet<Persion>();
            this.MyTYC = new HashSet<MyTYC>();
        }
    
        public int id { get; set; }
        public string name { get; set; }
        public Nullable<System.DateTime> createTime { get; set; }
        public Movies Movies { get; set; }
        public virtual ICollection<MyTYC> MyTYC { get; set; }
    }

Movies:( 跨库表)

public class Movies
    {
        public int ID { get; set; }
        public string Title { get; set; }
        public string ReleaseDate { get; set; }
        public string Genre { get; set; }
        public string Price { get; set; }
        public UserInfo UserInfo { get; set; }

    }

MyTYC

public partial class MyTYC
    {
        public int id { get; set; }
        public string name { get; set; }

    }

代码：

string sql = @"select * from UserInfo u 
inner join [Movies].dbo.Movies m on u.id=m.ID 
inner join MyTYC t on u.id=t.id";
            var data = conn.Query<UserInfo, Movies, MyTYC, UserInfo>(sql, (u, m, t) => { u.Movies = m; u.MyTYC.Add(t); return u; });

主要是  

u.Movies = m

u.MyTYC.Add(t)

一个是关联主键表（单个对象），一个是关联外键表（集合）。