soft prof

soft prof

  • NA
  • 7
  • 21.9k

Need help on Data synchronization application

Jun 6 2014 2:23 AM
Hi,
 
can anyone tell me an approach to perform data synchronization from two different data models using WCF services.
 
Requirement is as follows:
Data model-A has entity framework generated objects which needs to be mapped with the external Data model-B.
 
For example:
Data model - A: has X1,X2,X3... tables that are associated with each other.
Data model - B: has Y1,Y2,Y3... tables that are associated with each other.
 
let us assume X1 - Table has 5 columns with name A1,A2,A3,A4,A5 (A5 itself may be an enity).
Y1 - Table has 3 columns with name B1,B2,B3.
 
I need to update B1,B2 values in A4,A5 of X1. here it will be like B1-A4 is one-to-one mapping,
where as B2-A5 is one-to-many mapping.
 
My approach of implementation is:
Approach-1:
Find methods in Entity Framework to define entity objects of the data model-B which is exposed through OData interface, which has to be mapped with data model-A.
 
Approach-2.
Create SQL database table in the destination system out of the OData interface.
Convert this data table as entity objects through the Entity Framework.
Define the mapping with the Entity framework tool to map it with data model-A and save the mapping file.
Integration service has to read this mapping file and do the sync-up using entity frame work APIs.
 
Please let me know if there is any better approach and sample example is needed as well.