C Sharp Generic Dapper Query加入两个表

我是ac＃noobie，但这里是我要做的事情的要点：

    public IEnumerable<T> GetAll<T, K>(string schemaName) where T : GenericModel
    {
        var sql = @"SELECT * from " +
            schemaName + "." + T.getTableName() + " primaryTable LEFT JOIN " +
            schemaName + "." + K.getTableName() +
            " ForeignTable on ForeignTable.id = primaryTable." + T.getForeignFieldName();

        return _connection.Query<T, K, T>(sql, (primary, foreign) =>
        { (primary = T.getForeignFieldName()) = foreign; return primary; });
    }

例如，T = Employee，K = Person

    public IEnumerable<Employee> GetAll(string schemaName)
    {
        var sql = @"SELECT * from " + schemaName + 
            ".Employee primaryTable LEFT JOIN " + 
            schemaName + ".Person ForeignTable "+
            "on ForeignTable.id = primaryTable.person_id";
        return _connection.Query<EmployeeModel, PersonModel, EmployeeModel>
            (sql, (primary, foreign) => { primary.person = foreign; return primary; });
    }

GenericModel有getForeignFieldName()和getTableName() ，它们被派生类（ Employee和Person ）遮蔽

示例模型可能如下所示：

Person {
  int id;
  string Name;
  string address;
  int age;
}

Employee {
  int id;
  int person_id;
  Person person;
  double salary;

}

当然通用解决方案不起作用，我知道sql注入。我只想要一个通用的方法，我可以使用我用Dapper的Query（）函数描述的方式。

换句话说，你如何编写一个可以做到这一点的通用函数： Dapper的Multi Mapping