Creating an Example Web Services Project.
There are many tools and frameworks that can be used to build web services. We will follow the ASP.NET MVC framework for our project this week and future projects.
This walkthrough assumes that the .NET development environment has already been set up on your computer (what we did in Assignment 3 which is SSMS and VSC download). Now, we build a Derby database and then services needed for our Mobile apps (see script file in this folder) – you will need to execute the script in SSMS; this will create the Derby database on your computer. For this assignment:
- Download/Save the script file to a known location on your computer
- Start SSMS, connect to your local server (this is your local computer name), then Open a Project/Solution
- Locate/open the script file provided (will see the script content in the SSMS program pane)
- Highlight all of the script lines, then click;Execute
- Let the script finish execution completely – after successfully executing this script
- In the SSMS Object editor pane, see a new Derby database created
- Expand Derby then right click Database Diagrams to create a new Database Diagram
- Highlight two tables (DerbyNames and Leagues) and Add
Make two screenshots; one that shows the script completed successfully and one that shows the new Derby database diagram (which looks like the one in Figure 3-1, page 43). Submit these two screenshots as deliverables for Assignment 4.