This is an example repo corresponding to multiple lessons within the LearnHowToProgram.com walkthrough on creating a To Do List application in Section 4: Many-to-Many Relationships.
This project corresponds to the classwork and lessons that describe how to connect an ASP.NET Core MVC project to a MySQL database using Entity Framework Core with migrations. This project contains a one-to-many relationship between Item
and Category
, and a many-to-many relationship between Item
and Tag
. There are multiple lessons in this series. The first lesson in the series is Code First Development and Migrations.
There are multiple branches in this repo that are described more below.
Install the tools that are introduced in this series of lessons on LearnHowToProgram.com.
appsettings.json
.appsettings.json
, put in the following code, replacing the uid
and pwd
values with your own username and password for MySQL. For the LearnHowToProgram.com lessons, we always assume the uid
is root
and the pwd
is epicodus
.{
"ConnectionStrings": {
"DefaultConnection": "Server=localhost;Port=3306;database=to_do_list_with_many_to_many;uid=root;pwd=epicodus;"
}
}
dotnet ef database update
.
dotnet ef migrations add MigrationName
where MigrationName
is your custom name for the migration in UpperCamelCase. To learn more about migrations, visit the LHTP lesson Code First Development and Migrations.dotnet watch run
in the command line to start the project in development mode with a watcher.1_starter_project: This is the default branch with the starter code for the To Do List project as an ASP.NET Core MVC web application that is configured to use Entity Framework Core to communicate with a MySQL database as completed at the end of section 3. This branch is not meant to be run using the above instructions, as it is not configured to use EF Core migrations; instead it is meant to be used as a starting point for the refactor we begin in the LHTP lesson Code First Development and Migrations.
2_many_to_many_setup: This branch includes the code we added after working through the following lessons:
3_m2m_read_and_create: This branch includes the code we added after working through the following lessons:
4_m2m_update_and_delete: This branch includes the code we added after working through the following lessons:
5_model_validation: This branch includes the code we added after working through the following lesson:
6_data_from_multiple_db_tables: This branch includes the code we added after working through the following lesson: