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 tab

 

Assignment
Guidelines

 

• Create
  the Data Access tier and Data tier projects:

1. Create a class library project for the Data tier.

 

1. Add a new class library project the project created in
   Step 1 for the data access tier.

 

1. Add a typed DataSet using a new data source that
   connects to the Northwind sample database.

 

1. Select the database objects (customers, orders, order
   details, products, categories, and suppliers) tables.

 

1. 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.