表引用来自同一表的2个外键 - 实体框架

考虑我有以下表格TeamDetails的结构



团队详情

------------ -------------------

Id =>表的主键

TeamId =>表格团队的参考ID（导航属性（团队1））

DefaultTeam =>表格Team或Null的引用ID（Navidation Property（Teams））





这里的实体框架我正在使用导航属性并考虑我我在radGrid中显示数据。

我的问题是

当我尝试通过Teams.name和Teams1.name使用两者的导航属性时，我得到了数据仅在Teams.name列（即默认TeamId）和Teams1.name中，仅当数据与Teams.name中的任何其他元素匹配时，才会显示数据。

例如

团队|| DefaultTeam

==========================

Team1 || Team2

|| Team3（实际结果必须是Team4 || Team3）

Team3 || Team1



这里Team4不可见，因为它不在defaultTeam的任何元素中。我不知道这是这样的。如果你们解释它是这样显示并得到确切结果会很好

Consider I have the following structure of Table TeamDetails

Team Details
-------------------------------
Id => primary key of the table
TeamId=> references ID of table Team (Navidation Property (Teams1))
DefaultTeam=> references ID of table Team or Null (Navidation Property (Teams))


here in Entity framework I am using Navigation Properties and consider I am displaying the data in a radGrid.
my problem is
When i try to use the navigation property of both through Teams.name and Teams1.name, I get the data only under the column Teams.name (ie default TeamId) and in Teams1.name only when the data matches with any other elements in Teams.name , the data is displayed.
For example
Team || DefaultTeam
==========================
Team1 || Team2
|| Team3 (actual result has to be Team4 || Team3)
Team3 || Team1

here Team4 is not visible because it is not in any of the elements of defaultTeam. I dont know y this is showing like this. Would be good if u guys explain y it is showing like this and to get the exact result