ASP.NET Web Pages (Razor) cshtml中连接读取MySQL数据并显示

Index.cshtml

@page
@model IndexModel
@{
    ViewData["Title"] = "Home page";
}
@using MySql.Data.MySqlClient;

@{
    MySqlConnection connection = new MySqlConnection("server=localhost;user=root;database=tutorial;port=3306;password=root;sslmode=none");
    connection.Open();
    string sql = "SELECT * FROM employee";
    using var cmd = new MySqlCommand(sql, connection);
    using MySqlDataReader rdr = cmd.ExecuteReader();
    while (rdr.Read())
    {
        <span>ID : @rdr.GetInt32("id")</span>
        <br />
        <span>Employee Name : @rdr.GetString("emp_name")</span>
        <br />
        <span>Salary : @rdr.GetString("salary")</span>
        <br />
        <hr />
        <br />
    }
}
<div class="text-center">
    <h1 class="display-4">Welcome</h1>
    <p>Learn about <a href="https://docs.microsoft.com/aspnet/core">building Web apps with ASP.NET Core</a>.</p>
</div>

页面结果