將4個表映射到Dapper中的單個對象

您應該能夠通過將connection.Query擴展方法交給適當的參數化SQL語句來實現此目的，並將您的對像作為Type參數傳遞給它。

然後，Dapper將您的查詢神奇地映射到對象，假設您適當地對選擇列表中的項進行別名（即，使用對象的相應屬性名稱對它們進行別名）。

這些方面的東西應該​​有效：

public class SomeObject
{
   public int Field1 {get; set;}
   public int Field2 {get; set;}
   public int A {get; set;}
   public int B {get; set;}
   public int C {get; set;}
   public int D {get; set;}
}

using(var connection = SomeConnectionFactory.GetConnection())
{
    var yourObject = 
        connection.Query<SomeObject>("select tab1.someThing as Field1, " +
                                     "tab2.someThing as Field2, " +
                                     "tab4.onePotato as A, " +
                                     "tab4.twoPotato as B, " +
                                     "tab4.threePotato as C, " +
                                     "tab4.four as D " +
                                     "from someTable tab1 " +
                                     "join someTable2 tab2 on tab1.Id = tab2.Id " +
                                     "$$ etc etc for the other joins $$" +
                                    "where tab1.Id = :ID " + ,new {ID = someId});
};

需要注意的是，我已經將綁定變量語法用於Oracle數據庫（:)。您需要將其替換為數據庫的等效項。

希望這很有用。