Summary Files Commits Branches @commit @diff @stats
path: root / src / tutorials / connect-to-mysql-in-csharp-ef / article.md
diff options
context:
space:
mode:
Commit0555703568964839dc5cff7871f88f36614f1d20 (patch)
Author
 Syndamia <kamen.d.mladenov@protonmail.com>
2021-05-25 21:14:35 +0300
Committer
 Syndamia <kamen.d.mladenov@protonmail.com>
2021-05-25 21:14:35 +0300
Filesaa87ebc0be3a10a8675ec736c141d5b4f9b8a26e /src/tutorials/connect-to-mysql-in-csharp-ef/article.md
syndamia.com-0555703568964839dc5cff7871f88f36614f1d20.tar
syndamia.com-0555703568964839dc5cff7871f88f36614f1d20.tar.gz
syndamia.com-0555703568964839dc5cff7871f88f36614f1d20.zip
Parent4f4a450eac67c682f288b80ea5a8634a94abc78e (diff)
Compacted Connect to MySQL in CSharp tutorial into one page
1 files changed, 83 insertions, 0 deletions
-rw-r--r--src/tutorials/connect-to-mysql-in-csharp-ef/article.md83
diff --git a/src/tutorials/connect-to-mysql-in-csharp-ef/article.md b/src/tutorials/connect-to-mysql-in-csharp-ef/article.md
new file mode 100644
index 0000000..9067faa
--- /dev/null
+++ b/src/tutorials/connect-to-mysql-in-csharp-ef/article.md
@@ -0,0 +1,83 @@
+# Connect to MySql in C# and Entity Framework
+
+**Article Created: 21 May 2020** || **Last Edited: 25 November 2020**
+
+---
+
+In my experience, connecting a `C#` application to a `MySQL` database with Entity Framework can be quite tricky. Here, I share what works for me.
+
+## Contents
+[![🔗](/img/link-tabler.svg)](#Contents)
+
+1. [Preparation](#Preparation))
+2. [Connecting](#Connecting)
+
+# Preparation
+
+## MySql
+[![🔗](/img/link-tabler.svg)](#MySql)
+
+This tutorial doesn't cover it, but you'll need to have properly [installed and configured](https://dev.mysql.com/doc/mysql-installation-excerpt/5.7/en/) `MySQL`.
+
+## NuGet packages
+[![🔗](/img/link-tabler.svg)](#NuGet%20packages)
+
+You'll need to install two NuGet packages: [Microsoft.EntityFrameworkCore](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore) and [MySql.Data.EntityFrameworkCore](https://www.nuget.org/packages/MySql.Data.EntityFrameworkCore/).
+
+[Microsoft.EntityFrameworkCore](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore) is the [object-relational mapping](https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping) implementation we'll be using. It doesn't offer the specifics for connecting to a `MySQL` database, but it does everything else.
+
+[MySql.Data.EntityFrameworkCore](https://www.nuget.org/packages/MySql.Data.EntityFrameworkCore/) is what enables Microsoft.EntityFrameworkCore to connect to a `MySQL` database.
+
+# Connecting
+
+## Connection string
+[![🔗](/img/link-tabler.svg)](#Connection%20string)
+
+You can find a truckload of ways to make your connection string from places like [this](https://www.connectionstrings.com/mysql/) but in this case, I've found out that most don't work.
+After a lot of trial and error, 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_.
+
+## ASP.NET Startup
+[![🔗](/img/link-tabler.svg)](#ASP.NET%20Startup)
+
+If you are making an `ASP.NET` application, you'll need to put the connection string in the `ConfigureServices` method of the `Startup.cs` file.
+
+You'll also need to modify your `ConfigureServices` method, by replacing `.UseSQL` with `.UseMySQL`.
+
+The result should 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<UserServices, UserServices>();
+ services.AddDbContext<AppDbContext>(opt =>
+ {
+ opt.UseMySQL(CONNECTION_STRING);
+ });
+}
+```
+
+## DBContext child class
+[![🔗](/img/link-tabler.svg)](#DBContext%20child%20class)
+
+If you want to connect a `DBContext` child class to a `MySQL` database, one of the easiest ways to do it, is to override the `OnConfiguring` method.
+
+In the override, you'll need to call the `optionsBuilder.UseMySQL` method (`optionsBuilder` is a parameter of the method) with the connection string.
+
+```
+protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
+{
+ optionsBuilder.UseMySQL(CONNECTION_STRING);
+}
+```
+
+Et voilà! You should now be connected.