PagingMode.cs 478 B

12345678910111213141516171819202122
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. namespace Ant.SqlServer
  6. {
  7. /// <summary>
  8. /// 数据库分页类型
  9. /// </summary>
  10. public enum PagingMode
  11. {
  12. /// <summary>
  13. /// SQL2005或者2008下,使用ROW_NUMBER()分页
  14. /// </summary>
  15. ROW_NUMBER = 1,
  16. /// <summary>
  17. /// SQL2012下,使用OFFSET/FETCH NEXT分页
  18. /// </summary>
  19. OFFSET_FETCH = 2
  20. }
  21. }