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();
}
}
}
}