How to create relationship between two tables with revisions using Entity Framework
Posted
by Chris Ridenour
on Stack Overflow
See other posts from Stack Overflow
or by Chris Ridenour
Published on 2010-04-30T20:41:14Z
Indexed on
2010/04/30
20:47 UTC
Read the original article
Hit count: 262
So I am in the process of redesigning a small database (and potentially a much larger one) but want to show the value of using revisions / history of the business objects. I am switching the data from Access to MSSQL 2008.
I am having a lot of internal debate on what version of "revision history" to use in the design itself - and thought I had decided to add a "RevisionId" to all tables.
With this design - adding a RevisionId to all tables we would like tracked - what would be the best way to create Navigational Properties and Relationships between two tables such as
| Vendor | VendorContact |
where a Vendor can have multiple contacts. The Contacts themselves will be under revision. Will it require custom extensions or am I over thinking this?
Thanks in advance.
© Stack Overflow or respective owner
