【SqlSugar 】SqlSugar 连接操作MySQL数据库+ASP.NET Core Web API 6.0_sqlsugar asp.net core webapi

教程链接

参考学习博客地址
sqlSugar官网

Nuget 安装

SqlSugarCore

连接mysql

• 项目新建文件夹：Extensions
• 在Extensions文件夹添加类SqlsugarSetup.cs

    public static class SqlsugarSetup
    {

        public static void AddSqlsugarSetup(this IServiceCollection services, IConfiguration configuration,
string dbName = "db_master")
        {
            SqlSugarScope sqlSugar = new SqlSugarScope(new ConnectionConfig()
            {
                DbType = SqlSugar.DbType.MySql,
                ConnectionString = configuration[dbName],
                IsAutoCloseConnection = true,
            },
                db =>
                {
                //单例参数配置，所有上下文生效
                db.Aop.OnLogExecuting = (sql, pars) =>
                    {
                    //Console.WriteLine(sql);//输出sql
                };
                });
            services.AddSingleton<ISqlSugarClient>(sqlSugar);//这边是SqlSugarScope用AddSingleton
        }
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

• appsetting.json文件中追加，连接数据连接字符串（我这是mysql的）

 "db_master": "server=106.75.6.169;port=3306;user=root;password=password;database=minecraftdb"
1

新建数据库，表，获取数据库数据

• 项目新建文件夹：Models
• 在Models文件夹添加类User.cs，复制类的数据，不要删除命名空间

using SqlSugar;

namespace WebApiStudy_3_3.Models
{
    [SugarTable("T_User")]
    public class User
    {
        [SugarColumn(IsIdentity = true, IsPrimaryKey = true)]
        public int Id { get; set; }

        [SugarColumn(ColumnName="Name")]
        public string UserName { get; set; }
        public int Age { get; set; }

    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

• 新建控制器，并添加如下请求

namespace WebApiStudy_3_3.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class DbtestController : ControllerBase
    {
        public DbtestController(ISqlSugarClient db)
        {
            Db = db;
        }

        private ISqlSugarClient Db { get; }



        /// <summary>
        /// 
        /// </summary>
        [HttpPost]
        public bool CreateDb()
        {
            return Db.DbMaintenance.CreateDatabase();
        }

        /// <summary>
        /// 
        /// </summary>
        [HttpPost("Table")]
        public void CreateTable()
        {
             Db.CodeFirst.InitTables(typeof(User));
        }

        /// <summary>
        /// 
        /// </summary>
        [HttpGet]
        public List<User> GetTable()
        {
           return Db.Queryable<User>().ToList();

        }
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

三个请求分别是，创建数据库，创建表，获取全部数据。