net8.0一键创建支持(Orm-Sqlite-MySql-SqlServer)

Necore项目生成器 - 在线创建Necore模板项目 | 一键下载

DbController.cs

using Dm;using Microsoft.AspNetCore.Http;using Microsoft.AspNetCore.Mvc;using SqlSugar;using System.DirectoryServices.Protocols;using UnT.Template.Application.Responses;using UnT.Template.Domain;namespace UnT.Template.Controllers{ [Route(\"api/dbs\")] [ApiController] public class DbController : ControllerBase { private readonly ISqlSugarClient _sqlSugarClient; public DbController(ISqlSugarClient sqlSugarClient) { _sqlSugarClient = sqlSugarClient; } [HttpPost(\"insert\")] [Produces(\"application/json\")] [ProducesResponseType(typeof(ApiResponse), StatusCodes.Status200OK)] public IActionResult Insert() { try { _sqlSugarClient.Insertable(new Pro_Product { Name = DateTime.Now.ToFileTime().ToString() }).ExecuteCommand(); return Ok(new ApiResponse { Success = true, Data = true }); } catch (Exception ex) { return Ok(new ApiResponse { Success = false, Message = ex.Message, Data = false }); } } [HttpPost(\"count\")] [Produces(\"application/json\")] [ProducesResponseType(typeof(ApiResponse), StatusCodes.Status200OK)] public IActionResult Count() { try { var count = _sqlSugarClient.Queryable().Count(); return Ok(new ApiResponse { Success = true, Data = count }); } catch (Exception ex) { return Ok(new ApiResponse { Success = false, Message = ex.Message }); } } }}