To build on my last post, there is also something called the .NET Language Integrated Query for Relational Data (DLinq). If any of you remember the info going around about ObjectSpaces...well, I didn't care so much back then. After using LLBLGen Pro for quite a while now, I'm taking a serious interest in seeing how this technology develops. Frans Bouma, who is a very bright guy, has some interesting observations about DLinq. Specifically about the attribute-based approach that DLinq takes. One of the reasons I'm using LLBLGen Pro is so that I can target multiple database platforms using the adapter approach. I'd hate to see DLinq become proprietary to SQL Server.
Here's a demo...http://download.microsoft.com/download/4/7/0/4703eba2-78c4-4b09-8912-69f6c38d3a56/Dlinq.wmv