SubSonic is great!! I used it when 2.0 was released, need to look into it a bit more - maybe blog a bit about it.  It is very cool, plus it works with .Net 2.0 (Unlike Linq).

Linq is also very cool, but its still in beta and requires .net 3.5 so that might be a non-starter for you.  I do like it, not sure if I would pick Linq to SQL over SubSonic.