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
- Add model class with references and validation.
- Scaffold new and changed model pages
- Correct namespaces
- Add empty select items for Create and Edit, if necessary
- Set Index page title and h1
- Replace query parameters by path variables.
- Add search, sorting and alerts to Index model and view.
- Add help texts to Create and Edit views.
- Use text areas for long strings.
- Add page link to layout or admin page.
- Add count to Home page if interesting.
- Add missing data insights check, if applicable.
- Add changing sort orders to admin page, if applicable.
- Handle deletion (e.g. set references to null, cascade deletion, or prevent deletion).
- Migrate database.
- Seed database (if applicable).
See https://docs.microsoft.com/en-us/aspnet/core/tutorials/razor-pages/?view=aspnetcore-3.1 for details.