SqlQuery query = new Select(
DAL.UsersTable.IdColumn,"UserName")
.From<DAL.User>().LeftInnerJoin<DAL.User>(DAL.UsersTable.IdColumn,DAL.UsersTable.IdColumn)
.Where(DAL.UsersTable.IdColumn).IsGreaterThan(0);
//添加条件
query.And("UserName").IsEqualTo("admin");
//分页
query.Paged(pager ?? 1, 10);
query.And("UserName").Like("admin");
query.ExecuteTypedList<DAL.User>();