Sql Sugar 基本增删改查_sugarsql

1 按照《Sql sugar生成实体类》生成实体类

2 新建控制台项目，通过nuget安装SqlSugar

 3 将上面生成的实体类拷贝到项目

4  修改代码

using Entitys;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
 
namespace SqlSugarTest
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = "server=.;database=ZAS.WGT.Common;uid=sa;pwd=Server2012",//连接符字串
                DbType = DbType.SqlServer, //数据库类型
                IsAutoCloseConnection = true //不设成true要手动close
            });
 
            db.Aop.OnLogExecuting = (sql, pars) =>
             {
                 Console.WriteLine(sql);
             };
 
            //查询
            var list = db.Queryable<UserInfo>().ToList();
 
            //插入
            db.Insertable<UserInfo>(new UserInfo() { UserName = "zhangsan", Password = "zhangsan", Role = 2 }).ExecuteCommand();
 
            //更新
            db.Updateable(new UserInfo() { Id = 4, UserName="dxm", Role=2, Password="mypass"}).ExecuteCommand();
 
            //删除
            db.Deleteable<UserInfo>().Where(it => it.Id == 3).ExecuteCommand();
 
 
        }
    }
}