Hi,
I have a basic understanding of how fluent api's are used EF and how they define properties and relationships of the tables.
My question is how do I go about defining a collection of entities that are soft linked.
eg. Say I have a Contact table and a generic [MapTable].
[MapTable]
MapID
MapType
MapKey1
MapValue
Example data would be:
1,'ConToChar',1,'A'
2,'ConToChar',2,'B'
3,'ConToChar',3,'C'
4,'ProdToChar',1,'A'
5,'ProdToChar',2,'B'
The table matches contacts to a character, but it can also contains data that matches products to characters.
How do I got about providing a collection within my Contact class that list all the MapTable records for a contact using Code First conventions?
I hope that makes sense
Ryan
I have a basic understanding of how fluent api's are used EF and how they define properties and relationships of the tables.
My question is how do I go about defining a collection of entities that are soft linked.
eg. Say I have a Contact table and a generic [MapTable].
[MapTable]
MapID
MapType
MapKey1
MapValue
Example data would be:
1,'ConToChar',1,'A'
2,'ConToChar',2,'B'
3,'ConToChar',3,'C'
4,'ProdToChar',1,'A'
5,'ProdToChar',2,'B'
The table matches contacts to a character, but it can also contains data that matches products to characters.
How do I got about providing a collection within my Contact class that list all the MapTable records for a contact using Code First conventions?
I hope that makes sense
Ryan
