This application enables the user to interact with the data of [Production].[Products] table of the Adventure Works Database. The application is developed in ASP.NET MVC 5 using Entity Framework and has the ability to perform Creation, Retrieval, Updation and Deletion opertions on the data.
AdventureWorks Database is a Microsoft product sample for an online transaction processing (OLTP) database. The AdventureWorks Database supports a fictitious, multinational manufacturing company called Adventure Works Cycles. Data in products table is used for the application. The Product table is contained in the Production schema.This table contains the products sold or used in the manufacturing of sold products. The table holds about 500 rows of data in it.
The database is open source and can be obtained at the below link: http://msftdbprodsamples.codeplex.com/releases/view/93587
The application has the following features:
- Displaying Data in a Grid View.
- Pagination.
- Sorting on all columns.
- Data Validation.
- Data Deletion.
- Filtering Data using Product Name.
- New data can be added to the table by adding new rows.