blob: 61989f4db34ab719c72b46bf7ed177c2f56bb02c (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
# Connect to MySql in C# and Entity Framework - Connecting
[](#Connect%20to%20MySql%20in%20C#%20and%20Entity%20Framework%20-%20Connecting)
**Article Created: 21 May 2020** || **Last Edited: 25 November 2020**
[`<<`](./introduction.html) || [`< Preparations`](./preparation.html)
---
## Connection string
[](#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.
 In this example, the user id is _root_ and the port is _3306_.
## ASP.NET Startup
[](#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
[](#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.
|