Question on LINQ

[Merrion]

Second, why is the order of directives being thrown around? Every database system that I've worked with has had a similar syntax, some less similar than others, but they all have the same order of directives. Why does LINQ rearrange that?

For the second bit the reason is to do with intellisense and compiler determinism...

when you type:
SELECT A.

There is no way to know what list of fields to drop down because we don't know what A is until you type the FROM part.

This is also why so few database editors have intellisense like operations