Summary Files Commits Branches @commit @diff @stats
path: root / src / tutorials / connect-to-mysql-in-dotnet-ef
diff options
context:
space:
mode:
Commit48df2e3f4577d1f33768790ace58c51188091c92 (patch)
Author
 Syndamia <kamen.d.mladenov@protonmail.com>
2021-06-19 12:01:25 +0300
Committer
 Syndamia <kamen.d.mladenov@protonmail.com>
2021-06-19 12:01:25 +0300
Files156e54793bf54707012f4e62210cf7df5f63f738 /src/tutorials/connect-to-mysql-in-dotnet-ef
syndamia.com-48df2e3f4577d1f33768790ace58c51188091c92.tar
syndamia.com-48df2e3f4577d1f33768790ace58c51188091c92.tar.gz
syndamia.com-48df2e3f4577d1f33768790ace58c51188091c92.zip
Parent05fb609c086dd458809238482b1dc412bd0aeac1 (diff)
Reworked connect to mysql tutorial and renamed it
diff --git a/src/tutorials/connect-to-mysql-in-dotnet-ef/article.md b/src/tutorials/connect-to-mysql-in-dotnet-ef/article.md
new file mode 100644
index 0000000..4380e3b
--- /dev/null
+++ b/src/tutorials/connect-to-mysql-in-dotnet-ef/article.md
@@ -0,0 +1,87 @@
+# Connect to MySql in .NET and Entity Framework
+
+**Article Created: 21 May 2020** || **Last Edited: 19 June 2021**
+
+---
+
+I have found that connecting a `.NET` application to a `MySql` database (with Entity Framework) can be tricky. Here is what works for me.
+
+Also, [MySql.Data.EntityFrameworkCore](https://www.nuget.org/packages/MySql.Data.EntityFrameworkCore/) has been **depricated** since *October 2020*. If you need setup instructions with it, read [this](https://gitlab.com/Syndamia/syndamiadotcom/-/blob/0510e29526c6d7681587fff4c98a339e8c69e9b5/src/tutorials/connect-to-mysql-in-csharp-ef/article.md).
+
+## Contents
+<div></div>
+
+1. [NuGet packages](#NuGet%20packages)
+2. [Connection string](#Connection%20string)
+3. [Connecting](#Connecting)
+ 1. [ASP.NET Startup](#ASP.NET%20Startup)
+ 2. [DBContext child class](#DBContext%20child%20class)
+
+## NuGet packages
+[![🔗](/img/link-tabler.svg)](#NuGet%20packages)
+
+You'll need to install [Pomelo.EntityFrameworkCore.MySql](https://www.nuget.org/packages/Pomelo.EntityFrameworkCore.MySql/). It provides the stuff necessary for connecting and using a `MySql` database.
+
+## Connection string
+[![🔗](/img/link-tabler.svg)](#Connection%20string)
+
+There are [a lot](https://www.connectionstrings.com/mysql/) of ways to setup the connection string but I've found that 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 are using `MySQL Workbench` and you don't know your port and id, you can look at the server information from the `MySQL Connections` page.
+
+![MyServer root 127.0.0.1:3306](./img/connections.png) In this example, the user id is _root_ and the port is _3306_.
+
+## Connecting
+[![🔗](/img/link-tabler.svg)](#Connecting)
+
+To connect, you'll need to call the `UseMySql` method, either in [ASP.NET Startup](#ASP.NET%20Startup) or in a [DBContext child class](#DBContext%20child%20class).
+
+The method requires at least two arguments: connection string and `MySql` server version. The latter you can find, by going to the `Help/About Workbench` window inside `MySQL Workbench`.
+
+![](./img/about-workbench.png)
+![](./img/workbench-version.png)
+
+For the server version argument, create a new object of type `MySqlServerVersion` and give it's constructor a new object of type `Version`, to which you give the version numbers. The result should look something like this:
+
+```
+.UseMySql(CONNECTION_STRING, new MySqlServerVersion(new System.Version(8, 0, 21)))
+```
+
+Where `CONNECTION_STRING` is a (constant) variable that contains your connection string, and 8, 0, 21 are the version numbers.
+
+### ASP.NET Startup
+[![🔗](/img/link-tabler.svg)](#ASP.NET%20Startup)
+
+For `ASP.NET` applications, the connection must be put inside the `ConfigureServices` method of the `Startup.cs` file. If you already have a `.UseSQL` method call in there, just replace it with your `.UseMySql` method and arguments.
+
+The result should look something along the lines of:
+
+```
+// This method gets called by the runtime. Use this method to add services to the container.
+public void ConfigureServices(IServiceCollection services)
+{
+ ...
+ services.AddDbContext<AppDbContext>(opt =>
+ {
+ opt.UseMySql(...);
+ });
+}
+```
+<p></p>
+
+### DBContext child class
+[![🔗](/img/link-tabler.svg)](#DBContext%20child%20class)
+
+Another way to connect is via a `DBContext` child class (so, inside your own DB context). Just, override the `OnConfiguring` method and call the `.UseMySql` method from the `optionsBuilder` parameter.
+
+```
+protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
+{
+ optionsBuilder.UseMySql(...);
+}
+```
+<p></p>
diff --git a/src/tutorials/connect-to-mysql-in-dotnet-ef/img/about-workbench.png b/src/tutorials/connect-to-mysql-in-dotnet-ef/img/about-workbench.png
new file mode 100644
index 0000000..067d8ce
--- /dev/null
+++ b/src/tutorials/connect-to-mysql-in-dotnet-ef/img/about-workbench.png
Binary files differ
diff --git a/src/tutorials/connect-to-mysql-in-dotnet-ef/img/connections.png b/src/tutorials/connect-to-mysql-in-dotnet-ef/img/connections.png
new file mode 100644
index 0000000..aa7b408
--- /dev/null
+++ b/src/tutorials/connect-to-mysql-in-dotnet-ef/img/connections.png
Binary files differ
diff --git a/src/tutorials/connect-to-mysql-in-dotnet-ef/img/workbench-version.png b/src/tutorials/connect-to-mysql-in-dotnet-ef/img/workbench-version.png
new file mode 100644
index 0000000..bf5081d
--- /dev/null
+++ b/src/tutorials/connect-to-mysql-in-dotnet-ef/img/workbench-version.png
Binary files differ