Go Back

Chinook Music Store Album Managament System

C#
Razor
Entity Framework
CRUD
SQLite
Admin Page

2024 - 03 - 29

Custom made by me during my bachelor's year at the University of West of Scotland. Featuring .NET.

Screenshot of the login page for the admin system

Chinook Album Management System

A university project where I built a simple CRUD interface and got my chance to experience the Microsoft Java, I mean C# 😉

Source Code  

Background

The starting point for this project was using the received SQLite .db file to crerate a CRUD app that will allow fictional employees to manage the album stock.

What goals?

  • Gaining experience with C# and .NET to produce viable server side applications.
  • Templating markup with Razor and/or MVC model.
  • Working with ORM abstractions rather than raw SQL queries.
  • Using VSCode but also learning to install Omnisharp language server and configure .editorconfig in the environment which is an important skill for keeping the coding style consistent with a team’s preferences.
  • Spicing up work on the design process to look into modern CSS nesting patterns available native without preprocessors.

Features

  • Basic authentication with email and password being birthday (to allow teacher access, yet making it a little bit unguessable). Passwords are not stored, simple compared against formatted string based on DoB.
  • All basic CRUD operations for albums list.
  • Simple responsive UI.
  • Dedicated logic based on whether the Album or Artist exists in the database, has 0, 1 or more entries per Artist etc.

Recording of the Chinook app operation