qlSugar常用方法

查询

//查询所有，返回集合(数据库必须有跟泛型一样的实体)
var list = db.Queryable<SysUser>().ToList();

//查询单条
var a =db.Queryable<SysUser>().First(t =>t.SysUserId == "88888888-8888-8888-8888-888888888888");

//根据字段查询
var list = db.Queryable<SysUser>().Where("SysUserId='123'").ToList();

//查询前10条记录
var list = db.Queryable<SysUser>().Take(10).ToList();

//分页查询(数据库必须有跟泛型一样的实体)
var list = db.Queryable<SysUser>().ToPageList(1,20);

 //in 查询
 var list = db.Queryable<SysUser>().In(t => t.SysUserId, new string[] { "100026235090", "100026234935" }).ToList();

//模糊查询 FullName like '%管%'
var list = db.Queryable<SysUser>().Where(t => t.FullName.Contains("管")).ToList();

//等同 select * from SysUser
var i = db.Queryable<SysModel>().AS("SysUser").ToList();

//自定义Sql语句和Model,返回集合
var list = db.SqlQueryable<UserModel>("select SysUserId,FullName from SysUser").ToList();

//自定义语句返回Object对象(如果给了别名则是先查询所有，再根据别名过滤)
var obj= db.SqlQueryable<SysUser>("select  SysUserId,FullName from SysUser")
                 .First(t => t.SysUserId == "88888888");