ajunfly

摘要： 1：首先是 select ROW_NUMBER() over(order by id asc) as 'rowNumber', * from table1 生成带序号的集合2：再查询该集合的 第 1 到第 5条数据 select * from (select ROW_NUMBER() over(order by id asc) as 'rowNumber', * from table1) as temp where rowNumber between 1 and 5完整的Sql语句declare @pagesize int; declare @pageindex 阅读全文

摘要： 在读取的数据集进行跳跃查询，关键方法Skip().Take(); Skip跳过序列中指定的元素 Take从序列的开头返回指定数量的连续元素 var select = from n in entities.lib_reportinfo join e in entities.lib_enterprise on n.Ep_Guid equals e.Guid into temp_ne from tt in temp_ne.DefaultIfEmpty() select new { guid = n.Guid, epName = tt.Ep_Name, epTrade = tt.Ep_Trade, . 阅读全文