注意：VS2022企業(yè)版可以，社區(qū)版可能存在問題。實體名稱和字段和數(shù)據(jù)庫中的要一致。
1、創(chuàng)建項目，安裝SqlSugarCore、Pomelo.EntityFrameworkCore.MySql插件
2、文件結(jié)構(gòu)
2、appsettings.json
{
“Logging”: {
“LogLevel”: {
“Default”: “Information”,
“Microsoft.AspNetCore”: “Warning”
}
},
“AllowedHosts”: “*”,
“ConnectionString”: “Server=127.0.0.1;port=3306;database=blog_db;uid=root;pwd=123456;”
}
3、SqlSugarSetup.cs
using SqlSugar;
namespace MySqlApp.Db
{
public static class SqlSugarSetup
{
public static void AddSqlSugarSetup(this IServiceCollection services, IConfiguration configuration, string dbName= “ConnectionString”)
{
SqlSugarScope sqlSugar = new SqlSugarScope(new ConnectionConfig()
{
DbType = SqlSugar.DbType.MySql,
ConnectionString = configuration[dbName],
IsAutoCloseConnection = true,
},
db =>
{
db.Aop.OnLogExecuting = (sql, pars) =>
{
Console.WriteLine(sql);
};
});
services.AddSingleton(sqlSugar);
}
}
}
4、Program.cs
builder.Services.AddSqlSugarSetup(builder.Configuration);
5、blog_type.cs
namespace MySqlApp.Model
{
public class blog_type
{
public int type_id { get; set; }
public string type_name { get; set; } = string.Empty;
}
}
6、BlogTypeController.cs
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using MySqlApp.Model;
using SqlSugar;
namespace MySqlApp.Controllers
{
[Route(“api/[controller]”)]
[ApiController]
public class BlogTypeController : ControllerBase
{
private readonly ISqlSugarClient _db;
public BlogTypeController(ISqlSugarClient db) {
_db = db;
}
[HttpGet]
public IActionResult Get()
{
var a = _db.Queryable<blog_type>().ToList();
return Ok(a);
}
}文章來源：http://www.zghlxwxcb.cn/news/detail-651125.html
}
7、運行效果
文章來源地址http://www.zghlxwxcb.cn/news/detail-651125.html
到了這里，關(guān)于ASP.NET WEB API通過SugarSql連接MySQL數(shù)據(jù)庫的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
