src/sample/XXX.Plugin.FreeSql/Controller/FreeSQLDemoController.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using FreeSql.Internal.Model;

namespace XXX.Plugin.FreeSql
{
    /// <summary>
    /// Freesql数据库增删改查实例
    /// </summary>
    [ApiController]
    [Route("[controller]")]
    public class FreeSQLDemoController : ControllerBase
    {
        private readonly ILogger<FreeSQLDemoController> _logger;
        private readonly IWebHelper _webHelper;
        private readonly IFreeSQLDemoByDependency _userService;

        /// <summary>
        /// ctor
        /// </summary>
        /// <param name="logger"></param>
        /// <param name="webHelper"></param>
        /// <param name="userService"></param>
        public FreeSQLDemoController(ILogger<FreeSQLDemoController> logger,
            IWebHelper webHelper
            , IFreeSQLDemoByDependency userService)
        {
            _logger = logger;
            _webHelper = webHelper;
            _userService = userService;
        }

        /// <summary>
        /// 多库操作示例(切换数据库)
        /// </summary>
        /// <param name="dbKey">数据库别名标识</param>
        /// <returns></returns>
        [HttpPost("MultiFreeSql")]
        [ProducesResponseType(200, Type = typeof(string))]
        public async Task<string> MultiFreeSqlAsync(string dbKey = "sqlite")
        {
            var constring = await _userService.MultiFreeSqlAsync(dbKey);
            return constring;
        }

        /// <summary>
        /// 获取单行
        /// </summary>
        /// <param name="dbKey">数据库别名标识</param>
        /// <returns></returns>
        [HttpGet("user")]
        [ProducesResponseType(200, Type = typeof(string))]
        public async Task<User> GetList(string dbKey = "sqlite")
        {
            var user = await _userService.GetList(dbKey);
            return user;
        }

        /// <summary>
        /// 新增示例
        /// </summary>
        /// <param name="dbKey">数据库别名标识</param>