共用方式為

標準查詢運算子的查詢運算式語法 (Visual Basic)

  • 發行項

某些更常用的標準查詢運算子具有專用 Visual Basic 語言關鍵字語法，可將其呼叫為「查詢運算式」的一部分。 相較於「方法」對等項目，查詢運算式是一個不同且更具可讀性的表示查詢形式。 查詢運算式子句會在編譯時期轉譯成查詢方法的呼叫。

查詢運算式語法表

下表列出具有對等查詢運算式子句的標準查詢運算子。

方法 Visual Basic 查詢運算式語法
All Aggregate … In … Into All(…)

(如需詳細資訊，請參閱 Aggregate 子句。)
Any Aggregate … In … Into Any()

(如需詳細資訊，請參閱 Aggregate 子句。)
Average Aggregate … In … Into Average()

(如需詳細資訊，請參閱 Aggregate 子句。)
Cast From … As …

(如需詳細資訊，請參閱 From 子句。)
Count Aggregate … In … Into Count()

(如需詳細資訊，請參閱 Aggregate 子句。)
Distinct<TSource>(IEnumerable<TSource>) Distinct

(如需詳細資訊，請參閱 Distinct 子句。)
GroupBy Group … By … Into …

(如需詳細資訊，請參閱 Group by 子句。)
GroupJoin<TOuter,TInner,TKey,TResult>(IEnumerable<TOuter>, IEnumerable<TInner>, Func<TOuter,TKey>, Func<TInner,TKey>, Func<TOuter,IEnumerable<TInner>, TResult>) Group Join … In … On …

(如需詳細資訊，請參閱 Group Join 子句。)
Join<TOuter,TInner,TKey,TResult>(IEnumerable<TOuter>, IEnumerable<TInner>, Func<TOuter,TKey>, Func<TInner,TKey>, Func<TOuter,TInner,TResult>) From x In …, y In … Where x.a = b.a

-或-

Join … [As …]In … On …

(如需詳細資訊，請參閱 Join 子句。)
LongCount Aggregate … In … Into LongCount()

(如需詳細資訊，請參閱 Aggregate 子句。)
Max Aggregate … In … Into Max()

(如需詳細資訊，請參閱 Aggregate 子句。)
Min Aggregate … In … Into Min()

(如需詳細資訊，請參閱 Aggregate 子句。)
OrderBy<TSource,TKey>(IEnumerable<TSource>, Func<TSource,TKey>) Order By

(如需詳細資訊，請參閱 Order By 子句。)
OrderByDescending<TSource,TKey>(IEnumerable<TSource>, Func<TSource,TKey>) Order By … Descending

(如需詳細資訊，請參閱 Order By 子句。)
Select Select

(如需詳細資訊，請參閱 Select 子句。)
SelectMany 多個 From 子句

(如需詳細資訊，請參閱 From 子句。)
Skip Skip

(如需詳細資訊，請參閱 Skip 子句。)
SkipWhile Skip While

(如需詳細資訊，請參閱 Skip While 子句。)
Sum Aggregate … In … Into Sum()

(如需詳細資訊，請參閱 Aggregate 子句。)
Take Take

(如需詳細資訊，請參閱 Take 子句。)
TakeWhile Take While

(如需詳細資訊，請參閱 Take While 子句。)
ThenBy<TSource,TKey>(IOrderedEnumerable<TSource>, Func<TSource,TKey>) Order By …, …

(如需詳細資訊，請參閱 Order By 子句。)
ThenByDescending<TSource,TKey>(IOrderedEnumerable<TSource>, Func<TSource,TKey>) Order By …, … Descending

(如需詳細資訊，請參閱 Order By 子句。)
Where Where

(如需詳細資訊，請參閱 Where 子句。)

另請參閱