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