Disclaimer: All postings are provided "AS IS" with no warranties, and confer no rights. This weblog does not represent the thoughts, intentions, plans or strategies of Microsoft. Because a weblog is intended to provide a semi-permanent point-in-time snapshot, you should not consider out of date posts to reflect current thoughts and opinions.
There are really a whole bunch of great resources out there that help the community get up & running with LINQ.
Personally, with all the additional providers that I've seen (Qak Leaf List) - several of which I see great use for - LINQ to SharePoint and LINQ to LDAP / LINQ for AD.
In regards to tools, LINQ Pad is the tool that allows you to toil with the syntax, etc.
And now, here's a good 100+ pages on LINQ syntax in C# 3.0.
Book Preview: C# Query Expressions and Supporting Features in C# 3.0