We are in the process of a multi-year project in which we are building a new system and a new database in order to eventually replace the old system and database. Users use new and old systems as they change.
The problem we are facing is that an object in one system depends on an object in another system. We used representations , but limited ourselves to one of the technologies (Entity Framework) and are considering other options.
Another option that we are currently considering is replication . My boss is not thrilled with the extra service that might be causing. So, what other options are there for retrieving dependent data to the database it needs?
Update:
The technologies we use are SQL Server 2008 and Entity Framework. Both databases are in the same sql server instance, so linked servers should not be needed.
The limitation that we encounter with the Entity Framework is that we cannot create relationships between table-based entities and view-based entities. As far as I know, the relationship between the view and the table in the database cannot exist, so the edmx diagram cannot display it. And I cannot create a link manually without errors. He believes that all columns in the view are keys.
If I leave this, I get this error for each column in the view:
The association key property of the [...] key is not displayed.
If I try to change the "Entity Key" property to false in columns that are not a key, I get this error:
All key properties of an EntitySet [...] must be mapped to all key properties [...] of the VIEWNAME table.
, Entity Framework.
# 2
, Entity Framework , . , , , Entity Framework, . .