Project information

  • Category: Web Application
  • Project date: September 2021 - October 2021
  • Project URL: DVD Library
  • Technologies Used:
  • .NET Framework
    ASP.NET Web API
    C#
    AJAX
    ADO.NET
    LINQ
    T-SQL

This project is supplied in three parts. A SQL database, web API, and a separate HTML view for a DVD library application.

  • Engineered SQL database to store inventory, and stored procedures for CRUD functions
  • Built a first-party 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 query 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 test features