Connection string

- You can find many ways to impliment your connection string from here. + You can find many ways to impliment your connection string from here. From experience, this one works the best:
-

"server=localhost; port=YOUR-PORT; user id=YOUR-USER-ID; password=YOUR-PASSWORD; database=NAME-OF-DATABASE; SslMode=none"

If you don't know your port or user id, just look at the connection you use to connect to the database.

- MyServer root 127.0.0.1:3306 - +

+ MyServer root 127.0.0.1:3306 + In this example, the user id is root and the port is 3306.

@@ -42,7 +42,7 @@

Your ConfigureServices method should currenly look something like this: -

// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
@@ -54,16 +54,16 @@ });
}

- You need to change .UseSQL to .UseMySQL (refer to preparations if you haven't already). + You need to change .UseSQL to .UseMySQL (refer to preparations if you haven't already).

DBContext child class

- If you want to connect a DBContext child class to a MySQL databse, the best way is to override the OnConfiguring method. In the override, in optionsBuilder, call the .UseMySQL method (refer to preparations if you haven't already). + If you want to connect a DBContext child class to a MySQL databse, the best way is to override the OnConfiguring method. In the override, in optionsBuilder, call the .UseMySQL method (refer to preparations if you haven't already).

Example: -

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseMySQL(DataBaseContexts.ConnectionStringMySQL);
@@ -74,21 +74,21 @@
-