Communicate Sql Server over http

Question

Hi,

I just wanted to have some suggestions here. Right now, I have a client server application, using a windows application (.net) as a client and SQL server 2005 as a database server. The application is working fine and they are using within their intranet network; but suddenly a change comes in and they are saying that they would like to use over Internet. So, should I develop a web service which would be sitting between the windows application and database or the client (windows application) should communicate directly to the database server? What would be the better way to implement this?

Thanks Thurein

Answer 1

A web service, definitely. WCF Data Services are designed for this kind of scenario (exposing a database using a REST API).

Answer 2

I definitely would go the soap middleware route. Exposing ones database directly to the internet isn't very appetizing.