SLAM!
SharePoint List Association Manager
SharePoint has become THE must-have technology worldwide for collaboration-based applications. We've used it on countless projects and it's awesome. That said, we also know there are a lot of things that SharePoint alone simply can't do. To bridge that gap, we built SLAM!, our popular open-source tool, to kick SharePoint's power up a notch.
Basically, SLAM! turns conventional thinking about what SharePoint can and can't do on its head. This innovative tool makes it possible to "slam" data to an SQL server, which allows you to define relationships between SharePoint lists (or content types) and leverage those relationships in web parts or custom field types using familiar and straightforward SQL queries. This allows you to build real database-like applications while taking advantage of all the power SharePoint has straight out of the box.
Not to brag, (okay, we're bragging a little) but we've had a lot of success and great feedback from other developers about SLAM! Check it out for yourself on codeplex. You can also read our illustrated guide. Interested in API documentation? Get it here
Below is a video demonstrating the power of SLAM, how to begin using SLAM and one of our first add-ons to SLAM: list hierarchy (making SharePoint lists hierarchical!).