1-way sync between database/external provider

I have a situation where a database recieves information from user input, which has to send some of it's information to an external provider (in real time).

This also means problem. - External provider can be unreachable - The data can be malformed and throwed by provider - Etcetera

How would you handle this situation on best way? I see of it something like a PreAction/PostAction scenario.

1.PreAction will store in database.
2.PostAction sends the data to the external provider.
3.Some kind of provider that indicate and handle unsynced actions.

I'm just out for some sort of pseudo-code/idea of what way to go that are robust and reliable. maybe there exist some kind of usable pattern?
LVL 1
dingirAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Bob LearnedConnect With a Mentor Commented:
The Microsoft Sync Framework has both a managed and an unmanaged API, so it can be used with a .NET application.

Sync Framework Tutorial – Part #1 – Introduction
http://alexduggleby.com/2007/12/16/sync-framework-tutorial-part-1-introduction/

Microsoft Sync Framework Samples
http://archive.msdn.microsoft.com/sync
0
 
Bob LearnedCommented:
What you described sounds like a good description for the Microsoft Sync Framework.  

Introduction to Microsoft Sync Framework
http://msdn.microsoft.com/en-us/sync/bb821992
0
 
dingirAuthor Commented:
How would i use that into .net? Or do you mean its a .net assembly also?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.