TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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.
Reply
Answers (
0
)
what is the use of using wcf service for insertion? Explain?
Error: There was no endpoint listening at