通过

分页方法 (LINQ to Entities)

有些 LINQ 分页方法在 LINQ to Entities 查询中不受支持。有关更多信息，请参见 LINQ to Entities 查询中的标准查询运算符。下表列出了支持的和不支持的分页方法。

支持的和不支持的方法

方法 支持 Visual Basic 函数签名 C# 方法签名

ElementAt

不支持

 
Function ElementAt(Of TSource) ( _
source As IQueryable(Of TSource), _
index As Integer _
) As TSource
 
TSource ElementAt<TSource>(
this IQueryable<TSource> source,
int index
)

ElementAtOrDefault

不支持

 
Function ElementAtOrDefault(Of TSource) ( _
source As IQueryable(Of TSource), _
index As Integer _
) As TSource
 
TSource ElementAtOrDefault<TSource>(
this IQueryable<TSource> source,
int index
)

First

支持

 
Function First(Of TSource) ( _
source As IQueryable(Of TSource) _
) As TSource
 
TSource First<TSource>(
this IQueryable<TSource> source
)

First

支持

 
Function First(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Boolean)) _
) As TSource
 
TSource First<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, bool>> predicate
)

FirstOrDefault

支持

 
Function FirstOrDefault(Of TSource) ( _
source As IQueryable(Of TSource) _
) As TSource
 
TSource FirstOrDefault<TSource>(
this IQueryable<TSource> source
)

FirstOrDefault

支持

 
Function FirstOrDefault(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Boolean)) _
) As TSource
 
TSource FirstOrDefault<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, bool>> predicate
)

Last

不支持

 
Function Last(Of TSource) ( _
source As IQueryable(Of TSource) _
) As TSource
 
TSource Last<TSource>(
this IQueryable<TSource> source
)

Last

不支持

 
Function Last(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Boolean)) _
) As TSource
 
TSource Last<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, bool>> predicate
)

LastOrDefault

不支持

 
Function LastOrDefault(Of TSource) ( _
source As IQueryable(Of TSource) _
) As TSource
 
TSource LastOrDefault<TSource>(
this IQueryable<TSource> source
)

LastOrDefault

不支持

 
Function LastOrDefault(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Boolean)) _
) As TSource
 
TSource LastOrDefault<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, bool>> predicate
)

Single

不支持

 
Function Single(Of TSource) ( _
source As IQueryable(Of TSource) _
) As TSource
 
TSource Single<TSource>(
this IQueryable<TSource> source
)

Single

不支持

 
Function Single(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Boolean)) _
) As TSource
 
TSource Single<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, bool>> predicate
)

SingleOrDefault

不支持

 
Function SingleOrDefault(Of TSource) ( _
source As IQueryable(Of TSource) _
) As TSource
 
TSource SingleOrDefault<TSource>(
this IQueryable<TSource> source
)

SingleOrDefault

不支持

 
Function SingleOrDefault(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Boolean)) _
) As TSource
 
TSource SingleOrDefault<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, bool>> predicate
)

Skip

支持

 
Function Skip(Of TSource) ( _
source As IQueryable(Of TSource), _
count As Integer _
) As IQueryable(Of TSource)
 
IQueryable<TSource> Skip<TSource>(
this IQueryable<TSource> source,
int count
)

SkipWhile

不支持

 
Function SkipWhile(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Boolean)) _
) As IQueryable(Of TSource)
 
IQueryable<TSource> SkipWhile<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, bool>> predicate
)

SkipWhile

不支持

 
Function SkipWhile(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Integer, Boolean)) _
) As IQueryable(Of TSource)
 
IQueryable<TSource> SkipWhile<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, int, bool>> predicate
)

Take

支持

 
Function Take(Of TSource) ( _
source As IQueryable(Of TSource), _
count As Integer _
) As IQueryable(Of TSource)
 
IQueryable<TSource> Take<TSource>(
this IQueryable<TSource> source,
int count
)

TakeWhile

不支持

 
Function TakeWhile(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Boolean)) _
) As IQueryable(Of TSource)
 
IQueryable<TSource> TakeWhile<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, bool>> predicate
)

TakeWhile

不支持

 
Function TakeWhile(Of TSource) ( _
source As IQueryable(Of TSource), _
predicate As Expression(Of Func(Of TSource, Integer, Boolean)) _
) As IQueryable(Of TSource)
 
IQueryable<TSource> TakeWhile<TSource>(
this IQueryable<TSource> source,
Expression<Func<TSource, int, bool>> predicate
)

另请参见

概念

支持的和不支持的方法 (LINQ to Entities)