Data web-services for MS SQL server 2008R2

Pågår Lagt ut Aug 4, 2011 Betales ved levering
Pågår Betales ved levering

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 Programvarearkitektur SQL XML

Prosjekt-ID: #1153872

Om prosjektet

16 bud Eksternt prosjekt Aktiv Aug 11, 2011