In Progress

Data web-services for MS SQL server 2008R2

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.

Skills: .NET, IIS, Software Architecture, SQL, XML

See more: sql 2008r2, xml services, sql server web, iis web application, get web services, get services, xml sql server 2008r2, server technology, odata service, iis services, stored procedures, sql queries, sql code, sql access, soap server, soap rest, sample json data, rest web service, net web services, ms sql, ms s, iis web, data validation, data source sql, data point

About the Employer:
( 1 review ) Fort Lee, United States

Project ID: #1153872