注意:VS2022企业版可以,社区版可能存在问题。实体名称和字段和数据库中的要一致。
1、创建项目,安装SqlSugarCore、Pomelo.EntityFrameworkCore.MySql插件
2、文件结构
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);
}
}文章来源:https://www.toymoban.com/news/detail-651125.html
}
7、运行效果文章来源地址https://www.toymoban.com/news/detail-651125.html
到了这里,关于ASP.NET WEB API通过SugarSql连接MySQL数据库的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!