Entity Framework Include 導覽屬性的導覽屬性 | Entity Framework Include navigation property of navigation property

Posted on Edited on

問題背景

某個 DB 處理會撈出訂單、訂單明細、品項主檔
訂單明細是訂單的導覽
品項主檔是訂單明細的導覽

想要在 LINQ 撈出來資料時就把相關資料也加進來，避免後面處理時才去連 DB
但是又不能.Include("訂單明細").Include("品項主檔")
不知道怎寫

解答

參考這篇
https://stackoverflow.com/questions/614809/entity-framework-include-navigation-of-another-navigation-property

1
.Include("訂單明細.品項主檔")

這樣就行了