search

neuecc / LINQ-to-BigQuery

LINQ to BigQuery is C# LINQ Provider for Google BigQuery. It also enables Desktop GUI Client with LINQPad and plug-in driver.
MIT License
86 stars 16 forks source link

Syntax Order #3

Closed neuecc closed 10 years ago

neuecc commented 10 years ago

The syntax order is

From.Join.Select.[Where/GroupBy.Having].OrderBy.Limit

not select is last.

select repository_language as lang, count(*) as langCount
from [publicdata:samples.github_timeline]
group by lang
having lang is not null
order by langCount desc
neuecc commented 10 years ago

AsSubquery()

neuecc commented 10 years ago 
After Select, [ToString, Run, DryRun, AsEnumerable, ToArray]

                       | -> Select  -> OrderBy ->                    |
From -> Join -> Where -| -> OrderBy -> Select  ->                    | -> Limit
                       | -> Select  -> GroupBy  -> Having -> OrderBy |

after Select, Type hold <TSource, TResult> and use for OrderBy((source x, selected y) =>)