Is LINQ Query Syntax Related to T-SQL Order of Execution?

Question

Does the LINQ syntax match the T-SQL order of execution? I suspect it does and thus the reason for the change in query order between SQL and LINQ but wanted some proof.

Answer 1

The reason queries are written in the form (from i in dc.table where .... select i) is for intellisense. It has to know what you're working with before it can give you any good intellisense.

Similar to this question I think: http://stackoverflow.com/questions/1509106/why-didn't-the-linq-designers-stick-with-using-the-way-sql-is-written-today