diff options
Fully reworked website design. Remade pages in markdown. Configured files to work with ssg5.
1 files changed, 53 insertions, 0 deletions
| -rw-r--r-- | src/tutorials/connect-to-mysql-in-csharp-ef/connecting.md | 53 |
diff --git a/src/tutorials/connect-to-mysql-in-csharp-ef/connecting.md b/src/tutorials/connect-to-mysql-in-csharp-ef/connecting.md new file mode 100644 index 0000000..a91163c --- /dev/null +++ b/src/tutorials/connect-to-mysql-in-csharp-ef/connecting.md @@ -0,0 +1,53 @@ +# Connect to MySql in C# and Entity Framework - Connecting + +**Article Created: 21 May 2020** || **Last Edited: 21 July 2020** + +[\< Preparations](./preparation.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: + +``` +"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. + + 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: + +``` +// 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.UseSQL(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: + +``` +protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) +{ + optionsBuilder.UseMySQL(DataBaseContexts.ConnectionStringMySQL); +} +``` + |