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 Doctor
, 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.
- Clone this repo.
- Open the terminal and navigate to this project's production directory called "DoctorsOffice".
- Within the production directory "DoctorsOffice", create a new file called
appsettings.json
. - Within
appsettings.json
, put in the following code, replacing theuid
andpwd
values with your own username and password for MySQL. For the LearnHowToProgram.com lessons, we always assume theuid
isroot
and thepwd
isepicodus
.
{
"ConnectionStrings": {
"DefaultConnection": "Server=localhost;Port=3306;database=to_do_list_with_many_to_many;uid=root;pwd=epicodus;"
}
}
- Create the database using the migrations in the To Do List project. Open your shell (e.g., Terminal or GitBash) to the production directory "DoctorsOffice", and run
dotnet ef database update
.- To optionally create a migration, run the command
dotnet ef migrations add MigrationName
whereMigrationName
is your custom name for the migration in UpperCamelCase. To learn more about migrations, visit the LHTP lesson Code First Development and Migrations.
- To optionally create a migration, run the command
- Within the production directory "DoctorsOffice", run
dotnet watch run
in the command line to start the project in development mode with a watcher. - Open the browser to https://localhost:5001. If you cannot access localhost:5001 it is likely because you have not configured a .NET developer security certificate for HTTPS. To learn about this, review this lesson: Redirecting to HTTPS and Issuing a Security Certificate.
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:
- https://www.learnhowtoprogram.com/c-and-net/many-to-many-relationships/code-first-development-and-migrations
- https://www.learnhowtoprogram.com/c-and-net/many-to-many-relationships/many-to-many-relationships-join-entities
3_m2m_read_and_create: This branch includes the code we added after working through the following lessons:
- https://www.learnhowtoprogram.com/c-and-net/many-to-many-relationships/many-to-many-read-functionality
- https://www.learnhowtoprogram.com/c-and-net/many-to-many-relationships/many-to-many-create-functionality
4_m2m_update_and_delete: This branch includes the code we added after working through the following lessons:
- https://www.learnhowtoprogram.com/c-and-net/many-to-many-relationships/many-to-many-update-functionality
- https://www.learnhowtoprogram.com/c-and-net/many-to-many-relationships/many-to-many-delete-functionality
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: