i have junction tables on database can create many many relationships. in 1 case, have tables notificationformat , frequency , connect them junction called notificationformatfrequency.
i have tried add junction table list of entity types, have not found way. 'update model database...' not add junction table list of entity types, see in entity store.
after trial , failure, looked through , noticed none of purely junction tables show in diagram, nor available in entity types added diagram. however, in each case see 'association' between 2 tables, , see collection of notificationformats connected collection of frequencys.
so, expected behavior modeling many many relationships in ef? if so, perhaps don't want clutter diagram junction tables, , maybe don't care if there's way it. in advance.
yes, ef create intermediate tables you. given relationship, have both ends use cardinality of > 1 (*, 1...*).
you won't see intermediate tables types or in designer, appear in actual db.
Comments
Post a Comment