Saturday, February 04, 2012

LinqPad

I've found something even better than the Snippet Compiler I blogged about recently: LinqPad.

LinqPad doesn't just act as a snippet compiler, it also acts as a marvellous database interface.  Honestly, it's a joy to query a DB through Linq rather than SQL.  LinqPad will also show you the SQL it generated for a given Linq query, which can be a real timesaver (SQL is a kitchen sink full of terrible syntactic special cases).

SQL in One Page (or thereabouts)

I've written a very short summary of almost everything you need to know about SQL (one of the most dog-awful languages ever "designed"): SQL in One Page (or thereabouts).