Data web-services for MS SQL server 2008R2

In Progress Posted Aug 4, 2011 Paid on delivery
In Progress Paid on delivery

I need to have a sample VS 2010 C#/VB project, access to MS SQL Server 2008R2 (using SQL sample DB AdventureWorks2008R2 as a data source) using REST or SOAP web-services (REST is preferable). Output should be in XML or JSON (XML Atom is preferable).

Web-services should be hosted under IIS, not a SQL end-point.

User login/password should be a part of web-service request; validation of user’s credentials should be implemented.

Project should have 2 parts – call SQL queries (it should provide maximum syntax flexibility of queries, see oData); and call of stored procedures with set of parameters.

Technology should guarantee stability under http and https.

As a result I expecting to get source code of main project and installation project; short document with explanation of steps to develop projects; web-services installation and configuration of IIS for hosting these web-services.

Ideally I would like to get an application which does not require rebuild a project to create new entity functionality; it should be driven by config file.

.NET IIS Software Architecture SQL XML

Project ID: #1153872

About the project

16 proposals Remote project Active Aug 11, 2011