-
Notifications
You must be signed in to change notification settings - Fork 27
Open
Labels
enhancementNew feature or requestNew feature or requesthelp wantedExtra attention is neededExtra attention is needed
Description
e.g
[Table("Report")]
public class Report
{
[Key]
public string Id { get; set; }
public string Name { get; set; }
public string Type { get; set; }
public string Sql { get; set; }
public string Updatetime { get; set; }
public string ReportDataBaseId { get; set; }
public ReportDataBase ReportDataBase { get; set; }
}
[Table("ReportDataBase")]
public class ReportDataBase
{
[Key]
public string Id { get; set; }
public string Name { get; set; }
public string DbType { get; set; }
public string ConnectionString { get; set; }
}Query by
var sql = "SELECT * FROM Report A left JOIN ReportDataBase B on A.ReportDataBaseId = B.ID";
var result = Connection.Query<Report, ReportDataBase, Report>(sql,
(b, a) => { b.ReportDataBase = a; return b; });Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or requesthelp wantedExtra attention is neededExtra attention is needed