最终，在两个相关问题中，模式反馈（和缺乏EF反馈），我非常像上面的坏主意＃2所示。

Ultimately, based on good data schema feedback (and lack of EF feedback) in two related questions, I proceeded very much as shown in "Bad Idea #2", above.

我一直在工作有了这个，它符合我目前的所有需求。

I've been working with this and it meets all my current needs.

有关实施的其他部分的更多详细信息，请参阅：

See these for further details on the other bits of the implementation:

• SQL约束： https://dba.stackexchange.com / questions / 41387 / manymany-with-shared-relation


• EF5导航：自定义实体框架多对多导航属性

• SQL constraint: https://dba.stackexchange.com/questions/41387/manymany-with-shared-relation
• EF5 navigation: Custom Entity Framework many-to-many navigation property