C# send data from Application to Application

Question

Hi All: working on an asp.net mvc3 app that has a requirement to send data to another app which saves data to SQL.

So far i have one of the apps up and running and works well: Users login and do basic CRUD operations; this has been established using C# MVC3 framework and works well.

The issue: data needs to be saved to another external database where the host doesn't allow direct access to the SQL server and data must pass through IIS/Web-App/Firewall/Proxy etc.

The question: what is the best way to send data from one application to another and what protocol to use "HTTP? Webservice? VPN?....". The connection has to be secure in a way that the application receiving the data has to authenticate the application sending the data.

i know this sounds unnecessarily complex but the client is deadlock on this implementation. also this has to be implemented in ASP.NET C#/VB.NET. any suggestions?

thanks

Answer 1

Webservice would make the most sense - You can implement your own authentication system (As you know the same application is always going to call the web-service)

http://www.codeproject.com/KB/webservices/myservice.aspx

You could look at developing the service following the RESTful pattern (Using MVC) RESTful Web Services with ASP.NET MVC