Hi,
I have to build a service, which is kind of middle layer between System A and Third party system
This middle layer should be MVC framework
There can be multiple systems DB’s ( System A, System B….) which will interact with this middle Layer
The SQL database should be able make Async call to this middle layer system
The calling system and this middle layer are in different in house domains
This Middle Layer will receive XML from calling system DB which will contain data , this middle layer should be able to read/process and write XML and send it back to calling system ( based on third party system response)
I need suggestion on how to design this middle ware system.
Should I go for Web service? Web APIS? WCF? Or is there any better way to achieve this !