Summary Files Commits Branches @commit @diff @stats
path: root / website / tutorials / connect-to-mysql-in-csharp-ef / connecting.html
diff options
context:
space:
mode:
Commit64fbbd514733e42dd047bf65c511563a84ebd629 (patch)
Author
 Syndamia <kamen.d.mladenov@protonmail.com>
2020-07-21 23:17:07 +0300
Committer
 Syndamia <kamen.d.mladenov@protonmail.com>
2020-07-21 23:17:07 +0300
Filesfb472631d0b32a667b179f87b1e6c7692f09c0b7 /website/tutorials/connect-to-mysql-in-csharp-ef/connecting.html
syndamia.com-64fbbd514733e42dd047bf65c511563a84ebd629.tar
syndamia.com-64fbbd514733e42dd047bf65c511563a84ebd629.tar.gz
syndamia.com-64fbbd514733e42dd047bf65c511563a84ebd629.zip
Parent2d6a1a2b4a5bedfb5c669a48b64d84ed6265853e (diff)
Fully reworked website design. Remade pages in markdown. Configured files to work with ssg5.
1 files changed, 0 insertions, 81 deletions
-rw-r--r--website/tutorials/connect-to-mysql-in-csharp-ef/connecting.html81
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">
- &emsp;// This method gets called by the runtime. Use this method to add services to the container. <br>
- &emsp;public void ConfigureServices(IServiceCollection services) <br>
- &emsp;{ <br>
- &emsp;&emsp;services.AddControllersWithViews(); <br>
- &emsp;&emsp;services.AddTransient<UserServices, UserServices>(); <br>
- &emsp;&emsp;services.AddDbContext<AppDbContext>(opt => <br>
- &emsp;&emsp;{ <br>
- &emsp;&emsp;&emsp;opt.UseSQL(CONNECTION_STRING); <br>
- &emsp;&emsp;}); <br>
- &emsp;}
- </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">
- &emsp;protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) <br>
- &emsp;{ <br>
- &emsp;&emsp;optionsBuilder.UseMySQL(DataBaseContexts.ConnectionStringMySQL); <br>
- &emsp;} <br>
- </p>
- </p>
- </div>
-
- <br>
-
- <footer id="child-child-dir" class="footer"></footer>
- </body>
- <script type="text/javascript" src="../../js/footer.js"></script>
-</html>