SqlSugar实例测试代码

SqlSugar实例测试代码，拷贝能直接运行

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ORMDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlSugarClient db = new SqlSugarClient(
             new ConnectionConfig()
             {
                 ConnectionString = "********",
                 DbType = DbType.SqlServer,//设置数据库类型
                 IsAutoCloseConnection = true,//自动释放数据务，如果存在事务，在事务结束后释放
                 InitKeyType = InitKeyType.Attribute //从实体特性中读取主键自增列信息
             });

            //用来打印Sql方便你调式    
            db.Aop.OnLogExecuting = (sql, pars) =>
            {
                Console.WriteLine(sql + "\r\n" +
                db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
                Console.WriteLine();
            };
//启用事务回滚
db.Ado.UseTran(() =>
            {
            /*数据库表映射到实体类*/
            db.DbFirst.IsCreateDefaultValue().CreateClassFile("D:\\Work\\ExcelToDatabase\\ORMDemo\\ORMDemo\\model", "ORMDemo");

            /*查询*/
            var list = db.Queryable<T_OUTBARCODE>().ToList();//查询所有
            var getById = db.Queryable<T_OUTBARCODE>().InSingle(229745);//根据主键查询
            var getByWhere = db.Queryable<T_OUTBARCODE>().Where(it => it.serialno == "2004272043500337264701").ToList();//根据条件查询
            var total = 0;
            var getPage = db.Queryable<T_OUTBARCODE>().Where(it => it.serialno == "2004272043500337264701").ToPageList(1, 2, ref total);//根据分页查询
            
            /*新增*/
            var data = new T_OUTBARCODE() { barcode = "jack13245678900", materialno = "11122233300", serialno = "12346567400" };
            db.Insertable(data).ExecuteCommand();

            /*更新*/
            var data2 = new T_OUTBARCODE() { serialno = "123465674", barcode = "jack13245678900", materialno = "11122233344", id = 229744 };
            db.Updateable(data2).ExecuteCommand();

            /*删除*/
            db.Deleteable<T_OUTBARCODE>(229744).ExecuteCommand();
}
        }


    }
}