Business ASP.NET Core app hosted in Azure App service.

• Background
• Solution contents
• Database migrations
  • Drop database and reset migrations
  • Add a migration

Conselva is a non-profit organization that works in the field of water conservation. As a non-profit working with different partners and projects, they have unique requirements for their budget management and the organization of their day-to-day activities. This project addresses their need for a tool that allows them to control and report on their budget spending effectively.

The web application is designed to support the financial management needs of the organization. As a non-profit that relies on donations from multiple sources, the organization faces unique challenges in ensuring effective financial oversight and optimal use of its resources.

Funding is received from various channels, including grants and programs provided by different donors. Each donor often places restrictions on how their contributions may be allocated, creating the challenge of managing funds that are “labeled” or “restricted” for specific purposes.

Donors also impose diverse rules and compliance requirements regarding the use of their resources. This application addresses those needs by providing the financial visibility and management tools required to adhere to donor guidelines in a secure and efficient manner.

To achieve this, the system organizes the budget into distinct projects, each funded by a specific donor. Within each project, funds are further classified into spending categories aligned with donor requirements.

Additionally, project resources can be broken down into results and activities, providing a greater level of detail in how funds are allocated, spent, and reported.

This repository contains a Visual Studio Solution with 3 projects:

1. ConselvaBudget ASP.NET Core Razor Pages web app. This is the main application and provides a website for managing the budget for Conselva. It uses Entity Framework Core and a SQL database for storing the business data.
2. ConselvaBudget.Tests Tests project for the main web application.
3. ConselvaBudget.Seed Console app to seed the database with business data. It contains a reference to the main project to reuse the model and DBContext. The data itself is not included in the repo.

I commonly reset and add EF Core database migrations as I develop the data model. For reference, here are the steps that I follow.

These commands are to be executed in Visual Studio's Package Manger Console with the main web application project selected. Note that I specify the -Context since this project has more than one DBContext.

Deletes all migrations and creates a new migration with all the model information. This is especially useful early in development when the model can change drastically.

1. Delete the database.

Drop-Database -Context ConselvaBudgetContext

2. Delete the Migrations folder, Data/ConselvaMigrations.

3. Create a fresh migration with all the model data.

Add-Migration InitialCreate -Context ConselvaBudgetContext -OutputDir Data/ConselvaMigrations

4. Create the database and apply the migration.

Update-Database -Context ConselvaBudgetContext

1. Crate a new migration with the model changes.

Add-Migration ChangeDescription -Context ConselvaBudgetContext

2. Push the changes to the database.

Update-Database -Context ConselvaBudgetContext

To run the database migrations on the App Service using SSH:

1. Navigate to the deployed files.

cd /home/site/wwwroot

2. Run the migration bundle created by the deployment workflow.

./migrate