SqlSugar快速入门

配置SqlSugar

0、引入SqlSugarCore包

1、编写Context类

  public static SqlSugarClient db = new SqlSugarClient(new ConnectionConfig(){ConnectionString = "server = 127.0.0.1; Database = test; Uid = root; Pwd = root; AllowLoadLocalInfile = true;",DbType = DbType.MySql,//设置数据库类型IsAutoCloseConnection = true,//自动释放数据务，如果存在事务，在事务结束后释放});

2、配置实体类

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;namespace Blog.Core.Model.Models
{[SugarTable(tableName: "Person")]public class User{[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]public int Id { get; set; }public int Age { get; set; }public string? Name { get; set; }}
}

3、创建Service服务类进行数据库的CRUD

using Blog.core.IRepository;
using Blog.Core.Model.Models;
using static Blog.Core.Common.DbContext;
namespace Blog.Core.Repository
{public class UserRepository : IUserRepository{public  int Add(User user){var line = db.Insertable(user).ExecuteCommand();return line;}public int Delete(int UserId){var line = db.Deleteable<User>(new User{Id = UserId}).ExecuteCommand();return line;}public List<User> GetUsers(int Id){List<User> users;if (Id is not 0){users = db.Queryable<User>().Where(it => it.Id == Id).ToList();}else{users = db.Queryable<User>().ToList();}return users;}public int Update(User user){var res = db.Updateable<User>(user).ExecuteCommand();return res;}}
}

4、配置Controller进行路由

using Blog.core.Models;
using Blog.Core.Auth;
using Blog.Core.IServices;
using Blog.Core.Model.Models;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Blog.Core.Services;
namespace Blog.core.Controllers
{[Route("[controller]/[action]")][ApiController]public class UserController : ControllerBase{private readonly IUserService _userService;public UserController( IUserService userService){_userService = userService;}/// <summary>/// 增加/// </summary>/// <param name="user"></param>/// <returns></returns>[HttpPost]public int AddUser(User user){// User user = new User() { Id = 2024325, Name = "Czm", Age = 20 };return _userService.Add(user);}/// <summary>/// 删除/// </summary>/// <param name="id"></param>/// <returns></returns>[HttpDelete]public int DeleteUser(int id){return _userService.Delete(id);}/// <summary>/// 更新/// </summary>/// <param name="user"></param>/// <returns></returns>[HttpPut]public int UpdateUsre(User user){return _userService.Update(user);}/// <summary>/// 获取数据/// </summary>/// <param name="id"></param>/// <returns></returns>[HttpGet]public List<User> GetUser(int id){return _userService.GetUsers(id);}}
}