專業(yè)網(wǎng)站設(shè)計團隊日本櫻花免m38vcom費vps
注意：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);
}
}
}
7、運行效果
