About the project:

This project is supplied in three parts. A SQL database, RESTful API, and a series of HTML views.

• Engineered SQL database to store inventory, and stored procedures to safely execute CRUD operations.
• Built a ASP.NET Web API on the .NET Framework to provide web services and data access to the front-end
• Designed a separate web interface, styled with Bootstrap v4.5.0. Users are allowed to create, read, update, and delete DVD listings, as well as search by title, release year, director name, and rating.
• Implemented stored procedures with ADO.NET SQL parameters to secure data from SQL injection attacks.
• Utilized Dependency Injection to manage and control dependencies of the web application, in order to switch between a live ADO.NET database connection and a mock repository with sample data to perform unit testing.