Asp.net Mvc Framework Crud app Using Entity Framework MySql Code 1st approach

ASP.NET MVC 5 With Entity Framework And MySQL - Code First

https://youtu.be/61X-orQ-XJM?si=lXPH4jlcuY5rm2PF

1.) Install NuGet Package:
Install-Package MySql.Data.Entity ,
Install-Package MySqlConnector
Install-Package MySql.Data

2.) Create Product class in Models folder
Product.cs

public class Product
{
public int Id { get; set; }
public string Name { get; set; }
public decimal Price { get; set; }
}

3.) Create ApplicationDbContext class in Data folder

[DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))]
public class ApplicationDbContext : DbContext
{
public ApplicationDbContext() : base("MySqlConnection") { }

public DbSet<Product> Products { get; set; }
}

4.) Add Connection string in WenConfig file

<connectionStrings>
<add name="MySqlConnection" connectionString="Server=localhost;Port=3306;Database=Db_Invent;User=root;Password=------;" providerName="MySql.Data.MySqlClient" />
</connectionStrings>

5.) run below cmd in PMC
enable-migrations
Add-migration Db_XyqAdd
update-database