Web service for communication Database and .Net Service

Question

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 !

Laxmidhar Sahoo · Answer

Wen u did not understand and u
Should use web api that is compatible
With mvc

R Garg · Answer

Thanks Laxmidhar,   But i am not able to understand your suggestion completly. I should use WEB API or Web services.   Middleware system should be developep in ASP.net (c# Languauge) using MVC framework. Database i am using is SQL Server. Middleware system communicating to third party using XML Service (HTTP get) request.   Just needs to finalize communication means of Middleware system and Database. Confused about WEB API's, Web services and WCF?

Laxmidhar Sahoo · Answer

Hi
All these services return XML.
But depend upon ur prototype and structur.
If u use simple http protocol and only simple
Methods use web service,for http protocol and
Complex structure like different class use web api
For other protocol have to use wcf.
But wcf is complex for configutation