Summary Files Commits Branches @commit @diff @stats
path: root / src / tutorials / connect-to-mysql-in-csharp-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-csharp-ef
syndamia.com-48df2e3f4577d1f33768790ace58c51188091c92.tar
syndamia.com-48df2e3f4577d1f33768790ace58c51188091c92.tar.gz
syndamia.com-48df2e3f4577d1f33768790ace58c51188091c92.zip
Parent05fb609c086dd458809238482b1dc412bd0aeac1 (diff)
Reworked connect to mysql tutorial and renamed it
2 files changed, 0 insertions, 96 deletions
-rw-r--r--src/tutorials/connect-to-mysql-in-csharp-ef/article.md96
-rw-r--r--src/tutorials/connect-to-mysql-in-csharp-ef/img/connections.pngbin10067 -> 0 bytes
diff --git a/src/tutorials/connect-to-mysql-in-csharp-ef/article.md b/src/tutorials/connect-to-mysql-in-csharp-ef/article.md
deleted file mode 100644
index a028ae8..0000000
--- a/src/tutorials/connect-to-mysql-in-csharp-ef/article.md
+++ /dev/null
@@ -1,96 +0,0 @@
-# Connect to MySql in C# and Entity Framework
-
-**Article Created: 21 May 2020** || **Last Edited: 25 November 2020**
-
-## [*Due for rework*](/rework.html)
-
----
-
-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
-<div></div>
-
-1. [Preparation](#Preparation)
- 1. [MySql](#MySql)
- 2. [NuGet packages](#NuGet%20packages)
-2. [Connecting](#Connecting)
- 1. [Connection string](#Connection%20string)
- 2. [ASP.NET Startup](#ASP.NET%20Startup)
- 3. [DBContext child class](#DBContext%20child%20class)
-
-## Preparation
-[![🔗](/img/link-tabler.svg)](#Preparation)
-
-<span></span>
-
-### 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
-[![🔗](/img/link-tabler.svg)](#Connecting)
-
-<span></span>
-
-### 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.
diff --git a/src/tutorials/connect-to-mysql-in-csharp-ef/img/connections.png b/src/tutorials/connect-to-mysql-in-csharp-ef/img/connections.png
deleted file mode 100644
index aa7b408..0000000
--- a/src/tutorials/connect-to-mysql-in-csharp-ef/img/connections.png
+++ /dev/null
Binary files differ