0

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

Community
  • 1
  • 1
senfo
  • 28,488
  • 15
  • 76
  • 106

2 Answers2

0

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

Kane
  • 16,471
  • 11
  • 61
  • 86
  • I did look into My Generation (this post is relatively old now). I was just curious if there was anything out there that already existed. – senfo Aug 06 '09 at 14:52
0

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

Bob
  • 97,670
  • 29
  • 122
  • 130