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: create web service sql server 2008r2, sql server 2008r2 web service, sql 2008r2, sql create web service 2008r2, xml services, sql server web, iis web application, get web services, get services, c# call web service https, atom it services, xml sql server 2008r2, sql server or, server technology, odata service, iis services, ms access 2010, stored procedures, sql queries, sql projects, Sql code, SQL Access, soap server, soap rest, sample json data

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

Project ID: #1153872