DaedalicEntertainment/product-database

Company product database built as ASP.NET Core Web Application.

product-database

Company product database built as ASP.NET Core Web Application.

Setup

For instructions on how to host the database on Debian 10, see SETUP.md.

Development

Prerequisites

• Visual Studio 2019 16.4 or later with the ASP.NET and web development workload
• .NET Core 3.1 SDK or later
• SQL Server 2019 Express
• SQL Server Management Studio

Adding new data models

1. Add model class with references and validation.
2. Scaffold new and changed model pages
   1. Correct namespaces
   2. Add empty select items for Create and Edit, if necessary
   3. Set Index page title and h1
   4. Replace query parameters by path variables.
3. Add search, sorting and alerts to Index model and view.
4. Add help texts to Create and Edit views.
5. Use text areas for long strings.
6. Add page link to layout or admin page.
7. Add count to Home page if interesting.
8. Add missing data insights check, if applicable.
9. Add changing sort orders to admin page, if applicable.
10. Handle deletion (e.g. set references to null, cascade deletion, or prevent deletion).
11. Migrate database.
12. Seed database (if applicable).

See https://docs.microsoft.com/en-us/aspnet/core/tutorials/razor-pages/?view=aspnetcore-3.1 for details.