Unit 2 IP DSDD
Lowdown334
Assignment Details
The company has asked you to build a prototype of an n-tier system using the Northwind database as an example. The company wants to be able to add, edit, and delete records from the customers, orders, order details, products, categories, and suppliers tables. Your instructor will provide you the online link to the SQL Server database files (MDF and LDF).
Use this link:
Database scripts can be found in
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
Click on Northwind and pubs sample database for Microsoft SQL Server
and download file instnwnd.sql
Run script in Visual Studio to create the database
Assignment Guidelines
- Create the Data Access tier and Data tier projects:
- Create a class library project for the Data tier.
- Add a new class library project the project created in Step 1 for the data access tier.
- Add a typed DataSet using a new data source that connects to the Northwind sample database.
- Select the database objects (customers, orders, order details, products, categories, and suppliers) tables.
- Make sure the TableAdapters are stored in the Data Access tier and the DataSet class is added to the Data tier.
- Make sure that separate tiers are created for each layer by verifying that separate class libraries were created and the necessary references to the project were added.
- 4 years ago
- 20
Answer(1)
Purchase the answer to view it
NOT RATED
- soloution.pdf
other Questions(10)
- AS BELOW
- BUS 311 Business Law I Week 2 Assignmen
- Ethics
- For A-Plus Writer ONLY!!!!!!
- The key requirements for the Google infrastructure are scalability, reliability, performance and openness. Provide three example of where these requirements might be...
- help
- Discussion WK 1
- STR 581 Week 4 Learning Team Assignment - Strategy Paper
- choosing a friend
- 106 assn - for elprofessori