LLBL Gen Pro, you should take a look at this product.
I have been using
LLBL Gen Pro for a few years now. I must say it is the best O/R Mapper I have ever used. If you have not used
LLBL Gen Pro I highly recommend you take a look at the product. Basically the tool has a well designed GUI that you use to map your database to a set of objects in either C# or
VB.NET. You can target .NET Framework 1.1 or .NET Framework 2.0. Even further you can target the Compact Framework, which I have not had an opportunity to try.
When hit generate you get a
VS.NET project which provides with collections and entities of that map to the underlying tables in your database.
In these days of RAD it nice to have tool to map the database to datbindable objects get project out the door quickly. But then go back tune you queries and relationships, etc. Regenerate and have tighter DAL.