Linqer–Sql to Linq tool

Came across Linqer, a Sql to LINQ conversion tool. From some preliminary tests, I found that it worked pretty well given some complex queries.

Unfortunately, there is no free version of the tool and it costs $60. This would be a fabulous tool within LinqPad. Hopefully someday LinqPad will include this functionality.

Using Linq to concatenate strings

string[]words = new string[]{"hello","world"};
string concatenated = words.Aggregate((w,n) => w + " " + n);

Returns "hello world"

LINQ: Query Comprehension Syntax

via: http://www.albahari.com/nutshell/linqsyntax.aspx