网站建设项目预算,网盘搜索网站怎么做,网站建设低价网站到底便宜在哪,直播网站建设需要多少钱文章目录 配置SqlSugar0、引入SqlSugarCore包1、编写Context类2、配置实体类3、创建Service服务类进行数据库的CRUD4、配置Controller进行路由 配置SqlSugar
0、引入SqlSugarCore包
1、编写Context类 public static SqlSugarClient db new SqlSugarClient(new ConnectionCon… 文章目录 配置SqlSugar0、引入SqlSugarCore包1、编写Context类2、配置实体类3、创建Service服务类进行数据库的CRUD4、配置Controller进行路由 配置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.DeleteableUser(new User{Id UserId}).ExecuteCommand();return line;}public ListUser GetUsers(int Id){ListUser users;if (Id is not 0){users db.QueryableUser().Where(it it.Id Id).ToList();}else{users db.QueryableUser().ToList();}return users;}public int Update(User user){var res db.UpdateableUser(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 nameuser/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 nameid/param/// returns/returns[HttpDelete]public int DeleteUser(int id){return _userService.Delete(id);}/// summary/// 更新/// /summary/// param nameuser/param/// returns/returns[HttpPut]public int UpdateUsre(User user){return _userService.Update(user);}/// summary/// 获取数据/// /summary/// param nameid/param/// returns/returns[HttpGet]public ListUser GetUser(int id){return _userService.GetUsers(id);}}
}
