Sqlserver原生脚本分页

 page=1--页码
	lilm=20--条数
   select *from table  Offset (page-1)*lilm Rows Fetch Next lilm Rows only 

拼接字符串

string page=1--页码
string	lilm=20--条数
  string sql=$" select *from table  Offset {(page-1)*lilm} Rows Fetch Next {lilm} Rows only "

扩展orm ef分页

//链接
var data = DLL.AgentSystemDB.Query<DBOrder>();
//查询条件
            if (dBOrder.phone != null)
            {
                data = data.Where(a => a.phone.Contains(dBOrder.phone));
            }
           //分页
            List<DBOrder> list = data.OrderByDesc(a=>a.crtime).Skip((page - 1) * limit).Take(limit).ToList();

            Msgdata.count = data.Count();