Just in case you never heard about SubSonic yet, it’s a kickass DAL and I use it for a lot of my projects. Currently it supports SQL Server 2000 or 2005, MySQL and or Oracle (with SQLLite, SQLCE). They also offer a nice Starter-Kit which comes pre-wired with SubSonic, Membership, AJAX, Useful Utilities, and the FCK Editor. It’s based on the .NET 2.0 Framework but it’s automatically being converted by Visual Studio 2008 in case you use v3.5 already (which I strongly recommend).
With v2.1 they shipped a new Query Tool which is now fully capable of creating more complex queries, for example:
Northwind.CustomerCollection customersByCategory = new Select() .From() .InnerJoin() .InnerJoin(Northwind.OrderDetail.OrderIDColumn, Northwind.Order.OrderIDColumn) .InnerJoin(Northwind.Product.ProductIDColumn, Northwind.OrderDetail.ProductIDColumn) .Where(â€œCategoryIDâ€).IsEqualTo(5) .ExecuteAsCollection();
Read more about the new version here. Check it out, I don’t want to miss it anymore ;).