Summary Files Commits Branches @commit @diff @stats
path: root / src / tutorials / connect-to-mysql-in-dotnet-ef
diff options
context:
space:
mode:
Commit6a84efc70706da6a8a15394dcbbf90eaa7198cb1 (patch)
Author
 Syndamia <kamen@syndamia.com>
2025-07-24 21:12:39 +0300
Committer
 Syndamia <kamen@syndamia.com>
2025-07-24 21:12:39 +0300
Files4cbc8d0891685d88c9fd55125f8d8b2460d71d6c /src/tutorials/connect-to-mysql-in-dotnet-ef
syndamia.com-6a84efc70706da6a8a15394dcbbf90eaa7198cb1.tar
syndamia.com-6a84efc70706da6a8a15394dcbbf90eaa7198cb1.tar.gz
syndamia.com-6a84efc70706da6a8a15394dcbbf90eaa7198cb1.zip
Parentd8ab2f2019034aad3bdc5083aa80f4e43c57f774 (diff)
feat(tutorials): Converted half of the tutorials into dunbar
2 files changed, 78 insertions, 75 deletions
-rw-r--r--src/tutorials/connect-to-mysql-in-dotnet-ef/index.du78
-rw-r--r--src/tutorials/connect-to-mysql-in-dotnet-ef/index.md75
diff --git a/src/tutorials/connect-to-mysql-in-dotnet-ef/index.du b/src/tutorials/connect-to-mysql-in-dotnet-ef/index.du
new file mode 100644
index 0000000..b720264
--- /dev/null
+++ b/src/tutorials/connect-to-mysql-in-dotnet-ef/index.du
@@ -0,0 +1,78 @@
+# Connect to MySql in .NET and Entity Framework
+
+'define expected-reading 3 min
+'define created 21 May 2020
+'define edited 19 June 2021
+[$pagenav]
+
+:contents
+.numbered
+1. [url #nuget-packages NuGet packages]
+2. [url #connection-string Connection string]
+3. [url #connecting Connecting]
+ .numbered
+ 1. [url #asp.net-startup ASP.NET Startup]
+ 2. [url #dbcontext-child-class DBContext child class]
+
+
+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, [url https://www.nuget.org/packages/MySql.Data.EntityFrameworkCore/ MySql.Data.EntityFrameworkCore] has been =[depricated]= since *[October 2020]*. If you need setup instructions with it, read [url https://gitlab.com/Syndamia/syndamiadotcom/-/blob/0510e29526c6d7681587fff4c98a339e8c69e9b5/src/tutorials/connect-to-mysql-in-csharp-ef/article.md this].
+
+## NuGet packages
+
+You'll need to install [url https://www.nuget.org/packages/Pomelo.EntityFrameworkCore.MySql/ Pomelo.EntityFrameworkCore.MySql]. It provides the stuff necessary for connecting and using a `[MySql]` database.
+
+## Connection string
+
+There are [url https://www.connectionstrings.com/mysql/ a lot] 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.
+
+[image ./img/connections.png MyServer root 127.0.0.1:3306] In this example, the user id is _root_ and the port is _3306_.
+
+## Connecting
+
+To connect, you'll need to call the `[UseMySql]` method, either in [url #asp.net-startup ASP.NET Startup] or in a [url #dbcontext-child-class DBContext child class].
+
+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]`.
+
+[image ./img/about-workbench.png]
+[image ./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:
+
+```c#
+.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
+
+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:
+
+```c#
+// 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(...);
+ });
+}
+
+### DBContext child class
+
+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.
+
+```c#
+protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
+{
+ optionsBuilder.UseMySql(...);
+}
diff --git a/src/tutorials/connect-to-mysql-in-dotnet-ef/index.md b/src/tutorials/connect-to-mysql-in-dotnet-ef/index.md
deleted file mode 100644
index c5f0e9d..0000000
--- a/src/tutorials/connect-to-mysql-in-dotnet-ef/index.md
+++ /dev/null
@@ -1,75 +0,0 @@
-# Connect to MySql in .NET and Entity Framework
-
-## Contents
-
-1. [NuGet packages](#nuget-packages)
-2. [Connection string](#connection-string)
-3. [Connecting](#connecting)
- 1. [ASP.NET Startup](#asp.net-startup)
- 2. [DBContext child class](#dbcontext-child-class)
-
-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).
-
-## NuGet packages
-
-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
-
-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
-
-To connect, you'll need to call the `UseMySql` method, either in [ASP.NET Startup](#asp.net-startup) or in a [DBContext child class](#dbcontext-child-class).
-
-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:
-
-```csharp
-.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
-
-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:
-
-```csharp
-// 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(...);
- });
-}
-```
-
-### DBContext child class
-
-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.
-
-```csharp
-protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
-{
- optionsBuilder.UseMySql(...);
-}
-```