5

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

3
  • 2
    Are the applications running on the same machine? If so, I have used MSMQ successfully for secure and guaranteed message delivery. msdn.microsoft.com/en-us/library/ms711472%28v=vs.85%29.aspx Commented May 9, 2011 at 16:56
  • not really, they sit on completely different servers and Intranets Commented May 9, 2011 at 20:35
  • I have not remotely accessed MSMQ, but it is possible and used. Commented May 10, 2011 at 17:25

3 Answers 3

3

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

Sign up to request clarification or add additional context in comments.

Comments

3

Message queues (MSMQ) is definitely an option to consider.

Comments

1

It depends on the size of data, the rate you going to send it, the network(LAN or WAN) and many other factors.

Also do you need to encryption and authentication ?

I would use WCF to communicate, the binding should be selected accordingly to the requirments of your specific application.

Please provide more information.

2 Comments

data size is minimal and rate is also minimal, encryption is not required but preferred, authentication is required.
@Ziad J Some basic configuration for your need would be a WCF service with WSHttpBinding, transport encryption, and Userame/Password authentication.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.