.net core 连接mysql_asp.net core 连接mysql

打开VS，工具》NuGet包管理器》管理解决方案的NuGet程序包，搜索MySql.Data并安装

测试连接MySQL的代码：

using System;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using System.Threading.Tasks;

using Microsoft.AspNetCore.Mvc;

using MySql.Data.MySqlClient;

namespace ZZTCore.Controllers

{

public class LoginController : Controller

{

public IActionResult Index()

{

DataTable dt = new DataTable();

DataSet ds = new DataSet();

try

{

using (MySqlConnection con = new MySqlConnection("Data Source=localhost;User ID=root;Password=zt102545;Database=employees;Allow User Variables=True;Charset=utf8;"))

{

if (con.State != ConnectionState.Open)

con.Open();

MySqlDataAdapter sda = new MySqlDataAdapter("select * from titles", con);

sda.Fill(ds);

con.Close();

}

}

catch (Exception ex)

{

string s = ex.Message;

}

return View();

}

}

}

————————————————

版权声明：本文为CSDN博主「刹影」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。

原文链接：https://blog.csdn.net/zt102545/article/details/87919044