Simple Mapper Pattern C# Code Generation Template

Question

Can anybody recommend a decent C# Mapper Pattern code generation template that plays nicely with SQL stored procedures? I'm looking for something that generates POCO style entity objects, with a static mapper class for transferring data to/from the database through entity objects.

I understand that NHibernate can generate POCO style entity objects; however, NHibernate looses its appeal when you have a strong dependency on SQL stored procedures (which is a requirement of this project).

Bonus points awarded if you can also recommend a template that also generates the CRUD stored procs! ;-)

Edit: For this particular project, I am definitely not interested in any templates that generate Active Record pattern code (e.g, Subsonic, Linq to SQL, Entity Framework, etc.).

Answer 1

The very old, but free LLBLGen will generate CRUD stored procedures. It will also generate objects, but I forget how much like POCOs they are. I have a feeling there are more guts in them than not.

http://www.codeproject.com/KB/database/usingllblgen.aspx

Answer 2

Have you looked at using My Generation and using it to create your own templates?