C# – Simple Mapper Pattern C# Code Generation Template

ccode generationdaoorm

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.).

Best Answer

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

Related Topic