共用方式為


標準查詢運算子的查詢表示式語法 (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 Clause
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 Clause(連結子句)
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 Clause。)
SelectMany 多個 From 子句

(如需詳細資訊,請參閱 From Clause
Skip Skip

(如需詳細資訊,請參閱 Skip 子句
SkipWhile Skip While

(如需詳細資訊,請參閱 略過 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 條件

另請參閱