So, you are developing an application to run on SharePoint 2007, or WSS 3.0, and you hate to use CAML.  Up until now it would be an issue, but thanks to Bart de Smet you can now use LINQ (part of .NET 3.5) to querying your SharePoint lists just like any other database.

Bart has a project up on CodePlex (http://www.codeplex.com/LINQtoSharePoint) that will install the necessary items onto a box with Visual Studio 2008 Beta 2 to allow you to use LINQ against a SharePoint server, local or remote.  He also did an MSDN talk on the subject  recently which I hope they post for on-demand viewing. is now available for viewing at: http://channel9.msdn.com/ShowPost.aspx?PostID=353173