ELINQ allows you to use C# (or your .NET language of choice) to write strongly typed queries. It is capable to represent any practical SQL DML.
To demonstrate ELINQ capabilities we took questions from one such homework and implemented them in C# and ELINQ in a strongly typed way. Our goal is to show "pixel-perfect" SQL translation, EF integration, type safety and ease of use (we take the example as is, without trying to improve SQL).
This site is built with a wonderful Try .NET technology. All the examples are interactive, intellisense enabled and runnable with changes you may make. Enjoy!
All queries are executed in a transaction, which is rolled back at the end. Therefore no changes are persisted and each query can be executed multiple times producing same results. In addition we installed a console logger to inspect the executed SQL.