diff options
Reworked Connecting to MySQL in C# and Entity Framework tutorial
1 files changed, 15 insertions, 15 deletions
| -rw-r--r-- | src/tutorials/connect-to-mysql-in-csharp-ef/connecting.md | 30 |
diff --git a/src/tutorials/connect-to-mysql-in-csharp-ef/connecting.md b/src/tutorials/connect-to-mysql-in-csharp-ef/connecting.md index 650d6c2..9292bd5 100644 --- a/src/tutorials/connect-to-mysql-in-csharp-ef/connecting.md +++ b/src/tutorials/connect-to-mysql-in-csharp-ef/connecting.md @@ -1,30 +1,31 @@ # Connect to MySql in C# and Entity Framework - Connecting -**Article Created: 21 May 2020** || **Last Edited: 10 September 2020** +**Article Created: 21 May 2020** || **Last Edited: 25 November 2020** [`<<`](./introduction.html) || [`< Preparations`](./preparation.html) -## [*Due for rework*](/rework.html) - --- ## Connection string -You can find many ways to impliment your connection string from [here](https://www.connectionstrings.com/mysql/). -From experience, this one works the best: +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 don't know your port or user id, just look at the connection you use to connect to the database. +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 -If you are making an ASP.NET application, you will need to alter your Startup.cs file. -Your ConfigureServices method should currenly look something like this: +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. @@ -34,24 +35,23 @@ public void ConfigureServices(IServiceCollection services) services.AddTransient<UserServices, UserServices>(); services.AddDbContext<AppDbContext>(opt => { - opt.UseSQL(CONNECTION_STRING); + opt.UseMySQL(CONNECTION_STRING); }); } ``` -You need to change `.UseSQL` to `.UseMySQL` (refer to [preparations](./preparation.html) if you haven't already). - ## DBContext child class -If you want to connect a DBContext child class to a MySQL databse, the best way is to override the `OnConfiguring` method. In the override, in `optionsBuilder`, call the `.UseMySQL` method (refer to [preparations](./preparation.html) if you haven't already). -Example: +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(DataBaseContexts.ConnectionStringMySQL); + optionsBuilder.UseMySQL(CONNECTION_STRING); } ``` -Now you should be connected to your database. +Et voilĂ ! You should now be connected. |