diff options
1 files changed, 0 insertions, 81 deletions
| -rw-r--r-- | website/tutorials/connect-to-mysql-in-csharp-ef/connecting.html | 81 |
diff --git a/website/tutorials/connect-to-mysql-in-csharp-ef/connecting.html b/website/tutorials/connect-to-mysql-in-csharp-ef/connecting.html deleted file mode 100644 index c3fcdff..0000000 --- a/website/tutorials/connect-to-mysql-in-csharp-ef/connecting.html +++ /dev/null @@ -1,81 +0,0 @@ -<!DOCTYPE html> -<html lang="en-us"> -<html> - <head id="mySqlConnectEntityFrameworkCSharp"> - <meta charset="UTF-8"> - <meta name="description" content="Code you need to write to connect to MySql in C# and Entitiy Framework"> - <meta name="keywords" content="programming, C#, tutorial, mysql, entity, framework, database, asp.net, dbcontext, connectionstring, connection"> - <meta name="author" content="Kamen Mladenov"> - <meta name="robots" content="index, follow"> - <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <link rel="icon" href="../../img/favicon.png" type="image/png"/> - <link rel="shortcut icon" href="../../img/favicon.png" type="image/png"/> - <title>Connect to MySql in C# and Entitiy Framework - Connecting</title> - <link rel="stylesheet" href="../../css/styles.css"> - <link rel="stylesheet" href="../../css/styles-multiple-page-articles.css"> - </head> - - <body id="Connecting"> - <div class="header"> - <script type="text/javascript" src="../../js/header.js"></script> - </div> - - <div class="page"> - <h2>Connection string</h2> - <p> - You can find many ways to impliment your connection string from <a href="https://www.connectionstrings.com/mysql/" class="hyperlink">here</a>. - From experience, this one works the best: <br> - <p class="code"> - "server=localhost; port=YOUR-PORT; user id=YOUR-USER-ID; password=YOUR-PASSWORD; database=NAME-OF-DATABASE; SslMode=none" - </p> - If you don't know your port or user id, just look at the connection you use to connect to the database. - </p> - <p class="tutorial-p"> - <img src="./img/connections.png" alt="MyServer root 127.0.0.1:3306" class="tutorial-img" width="262" height="152"> - <span class="tutorial-text"> - In this example, the user id is <i>root</i> and the port is <i>3306</i>. - </span> - </p> - <br> - <h2>ASP.NET Startup</h2> - <p> - If you are making an ASP.NET application, you will need to alter your Startup.cs file. - </p> - <p> - Your ConfigureServices method should currenly look something like this: - <p class="code"> -  // This method gets called by the runtime. Use this method to add services to the container. <br> -  public void ConfigureServices(IServiceCollection services) <br> -  { <br> -   services.AddControllersWithViews(); <br> -   services.AddTransient<UserServices, UserServices>(); <br> -   services.AddDbContext<AppDbContext>(opt => <br> -   { <br> -    opt.UseSQL(CONNECTION_STRING); <br> -   }); <br> -  } - </p> - You need to change <span class="code">.UseSQL</span> to <span class="code">.UseMySQL</span> (refer to <a href="./preparations" class="hyperlink">preparations</a> if you haven't already). - </p> - <br> - <h2>DBContext child class</h2> - <p> - If you want to connect a DBContext child class to a MySQL databse, the best way is to override the <span class="code">OnConfiguring</span> method. In the override, in <span class="code">optionsBuilder</span>, call the <span class="code">.UseMySQL</span> method (refer to <a href="./preparations" class="hyperlink">preparations</a> if you haven't already). - </p> - <p> - Example: - <p class="code"> -  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) <br> -  { <br> -   optionsBuilder.UseMySQL(DataBaseContexts.ConnectionStringMySQL); <br> -  } <br> - </p> - </p> - </div> - - <br> - - <footer id="child-child-dir" class="footer"></footer> - </body> - <script type="text/javascript" src="../../js/footer.js"></script> -</html> |