3.Query

NOLOCK

Except for UpdateSelect can use.

con.QuerySet<SysUser>().WithNoLock().Get();

GET

Get the first data by filtering condition

con.QuerySet<SysUser>().Where(a => a.Email == "[email protected]").Get()

TOLIST

You can also query qualified data list.

con.QuerySet<SysUser>().Where(a => a.Email == "[email protected]").OrderBy(b => b.Email).Top(10).Select(a => a.Email).ToList();

PAGELIST

con.QuerySet<SysUser>().Where(a => a.Email == "[email protected]")
                 .TOP(2)
                 .Select(a => new SysUser { Email = a.Email, CreateDatetime = a.CreateDatetime, SysUserid = a.SysUserid })
                 .PageList(1, 10);

UPDATESELECT

First update then select

con.QuerySet<SysUser>().Where(a => a.Email == "[email protected]")
                .OrderBy(a => a.CreateDatetime)
                .Select(a => new SysUser { Email = a.Email })
                .UpdateSelect(a => new SysUser { Email = "[email protected]" });

ExpressionBuilder

var where = ExpressionBuilder.Init<SysUser>();

if (string.IsNullOrWhiteSpace(param.Email))
    where = where.And(a => a.Email == "[email protected]");

if (string.IsNullOrWhiteSpace(param.Mobile))
    where = where.And(a => a.Mobile == "18988565556");

con.QuerySet<SysUser>().Where(where).OrderBy(b => b.Email).Top(10).Select(a => a.Email).ToList();

STARTSWITH

con.QuerySet<SysUser>().Where(a => a.Mobile.StartsWith("59332")).ToList();

ENDWITH

con.QuerySet<SysUser>().Where(a => a.Mobile.EndWith("59332")).ToList();

CONTAINS

con.QuerySet<SysUser>().Where(a => a.Mobile.Contains("59332")).ToList();

COUNT

con.QuerySet<SysUser>().Where(a => a.Email == "[email protected]").Count();

SUM

con.QuerySet<SysUser>().Sum(a => a.Age);

EXISTS

con.QuerySet<SysUser>().Where(a => a.Email == "[email protected]").Exists();