I want to say sorry right now because this question might become a little bit of a mess, english isn’t my native language and I’m not used to formulating longer text’s like this.
Alright, let’s say I have 5 tables
PKTable1 | FKTable3 | Quantity | Position
PKTable2 | Date | Status | FKTable4
PKTable3 | ArticleName | Price
PKTable4| Name | FirstName
PKTable5 | FKTable1 | FKTable2
Can I somehow fetch for example Name and FirstName from Table4 only using Table5?
I’m using C#, LinQ and EntityFramework if that helps