Đang Thực Hiện

Windows Azure REST Web services that read and update SQL Server data

I have a homework assignment that should take less than a couple of hours for someone experienced with this.

I need step-by-step instructions for the following:

1. Create a new Visual Studio 2012 C# project that implements 4 very simple REST Web services

2. Create a new Teacher - Implement a REST Web service that is a POST against a Teachers resource (creates a new teacher in the SQL Server table called "Teachers")

3. Get all Teachers - Implement a REST Web service that is a GET against a Teachers resource (returns all teachers from a SQL Server table called "Teachers")

4. Get a specific Teacher - Implement a REST Web service that is a GET against a Teacher resource (returns a specified teacher from a SQL Server table called "Teachers" using the passed ID as the key)

5. Update a specific Teacher - Implement a REST Web service that is a PUT against a Teacher resource (updates a specified teacher in a SQL Server table called "Teachers" using the passed ID as the key)

** NOTE: The services are defined below in REST WEB SERVICE DEFINITIONS

6. Within each service, show me code to read from and update data for an Azure SQL Server database, and how to return the data or error to the client.

7. Build and deploy the project to Azure (I have an account and so forth); just tell me how to get my services published so that they can be called from a client.)

8. Code a very simple C# console application that successfully calls each service and prints to the screen the returned REST response bodies.

When referring to code (such as implementing and consuming the services, and interacting with the SQL Server database), I need template code that I can easily copy and paste, and then modify for my needs.

In other words, don't just write, "Create a project" or "Implement a controller". I need very specific step-by-step instructions as well as template code.

FOR EXAMPLE:

1. Open Visual Studio 2012

2. Click N to create a new project

3. Click the ___ template

4. Name the project

5. Click the OK button

6. Open Solution Explorer

7. Right click the ____ node and select ___ from the context menu

8. Open ___ file and insert the following code:

...

DATABASE INFO

Database Name: Assignment

User: Student

Password: school

Table: Teachers

Columns: ID (numeric primary key), Name (varchar)

REST WEB SERVICE DEFINITIONS

1. Create a new Teacher - POST {URL}/teachers

Creates a new record in the SQL Server table called "Teachers"

The client should send:

POST {URL}/teachers

{name}

The service should create a new record in the SQL Server called "Teachers" and return as follows where ID is the key to the new record (if successful)

HTTP/1.1 201 Created

[REST Header Info]

On error, return the standard defined REST error

2. Get all Teachers - GET {URL}/teachers

Read all records from the SQL Server table called "Teachers" and return them as follows:

HTTP/1.1 200 Ok

[REST Header Info]

{name}

...

3. Get a specific Teacher - GET {URL}/teacher/{ID}

Returns record from the SQL Server table called "Teachers" where [url removed, login to view] == {ID} and return as follows:

HTTP/1.1 200 Ok

[REST Header Info]

{name}

If the ID is not found, 404 should be returned

4. Update a specific Teacher - PUT {URL}/teacher/{ID}

The client should send:

PUT {URL}/teacher/{ID}

[REST Header Info]

{name}

The service should update the record in the SQL Server table where [url removed, login to view] == {ID} and return as follows:

HTTP/1.1 200 Ok

[REST Header Info]

{name}

If the ID is not found, 404 should be returned

Visual Studio 2012 project needs to be an ASP.NET MVC 4 project type

Kỹ năng: Azure, Lập trình C#, SQL

Xem thêm: rest sql server, windows-azure, windows 8 programming, web studio 4, web programming services, web programming service, web azure, web application azure, t sql programming, template code web, sql server web, services programming, rest programming, read and write the words, programming sql, programming homework service, programming definitions, primary services, post my services, node programming, node explorer, my sql create database, i need someone to write my assignment, how to get the web services from the url, get web services

Về Bên Thuê:
( 10 nhận xét ) Pasco, United States

Mã Dự Án: #4555771

Đã trao cho:

hoangquocdat

Hi, I have experience with Windows Azure, SQL Azure and good knowledge with WCF RESTful service. I am confident that I can help you on this project. Look forward to work with you. Regards,

$263 USD trong 2 ngày
(39 Đánh Giá)
6.0

6 freelancer đang chào giá trung bình $223 cho công việc này

samitXI

Please check your inbox. Thanks

$257 USD trong 5 ngày
(12 Đánh Giá)
4.9
Reza2012

Hi I want do the job. Please see my profile. thanks.

$200 USD trong 5 ngày
(4 Đánh Giá)
3.5
Alcatraz87

Hi, I can help you with this project. Kindly check out my profile and previous reviews. Thanks.

$250 USD trong 4 ngày
(5 Đánh Giá)
3.0
vickkey7

I am ready to start this project..

$210 USD trong 7 ngày
(0 Đánh Giá)
0.0
manicoder9898

Hi I'm very interested in your job post involving these skills. I have good experience in Metro Style Apps,WinRT, MVC, MVC3, RAZOR, C#, SQL, LINQ, HTML, CSS, JQUERY, JAVA Script, VB Script and JSON, I have also deve Thêm

$155 USD trong 3 ngày
(0 Đánh Giá)
0.0