Connect to MySql in C# and Entitiy Framework

Connection string

- 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 - - In this example, the user id is root and the port is 3306. - -

-
-

ASP.NET Startup

- If you are making an ASP.NET application, you will need to alter your Startup.cs file. -

- 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)
- {
- services.AddControllersWithViews();
- services.AddTransient();
- services.AddDbContext(opt =>
- {
- opt.UseSQL(CONNECTION_STRING);
- });
- } -

- 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). -

- Example: -

- protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
- {
- optionsBuilder.UseMySQL(DataBaseContexts.ConnectionStringMySQL);
- }
-

- Connecting to MySql through C# can be quite tricky. I and many others have wasted too much time trying to figure this out. For that reason, I am making this tutorial. -

- First are preparations in which I will talk about what you need to have for this to work. -

- Second is the actual connecting. This covers changes in code and the all mighty connection string. -

MySql

- First of all, you need to insall MySql. You can do that from here. This is the installer. Skip this step, if you have already done it. -

NuGet packages

- For an Entity Framework, Microsoft.EntitiyFrameworkCore is the goto packet in this tutorial. -

- Although Microsoft.EntitiyFrameworkCore does offer connectivity with MS SQL server, it doesn't offer anything for MySql.
- That's why we also need to install another package: MySql.Data.EntitiyFrameworkCore. -