Hi,
though I suppose it's a very common subject I couldn't find any post on this so if you've seen another post that answers my question please send me the link!
Thing is my company is considering using NHibernate as the ORM for a new project but I couldn't find any code generator without bugs and with all the features that other code generators (like LLBLGen) provide. I've already tried:
- Simon Green's templates for Codesmith
- a few templates for MyGeneration (Template Object Mapping 1.1 and OM 0.7.3)
-Codus.
None of these have generated a valid class/mapping file for the pubs DB on SQL Server 200 (I've added the PK where needed). I'll appreciate any help on the subject since I assume that developing a new template would be very difficult and could take a very long time to develop.

Thanks
Diego Marcet

Diego,

The lack of code-generation in NHibernate is viewed as an important feature by the majority of its user-base. AFAIK, all the NH code-generation tools out there only get you "templates" to get you started, but using NH requires at least some ability/willingness to tweak mapping files/domain objects at the code level.

If you'd prefer a graphical tool for working with mapping files, I think Ayende Rahien has something (though I don't use it). Still, you'll have to be familiar with the mapping functions and limitations on some level.

If a completely code-generated DAO layer is a part of your project requirements, or just very important for you, there are many tools that will work better for you (LLBLGen, TierDeveloper, etc., etc.). You might want to do a little more research on the tool space, see if something is a better fit for you or your project.

** Disclaimer **

I'm not really a spokesman for NH, but I think this is an accurate representation.

I use MatsSoft ObjectMapper, which is now part of the Puzzle.NET-project.
Generates the xml-mapping file and all classes I need.

As mvanwesemael mentioned I use OjectMapper too. It's definitively worth a look.

You should keep in mind that those tools give you a nice start, but some changes have to be applied manually. Like marcal mentioned most tools give you "just" templates, which furthermore need some tweaks.
I have tried a few open source/free tools and my conclusion so far is that ObjectMapper is the most complete one. Give it a try. :)

Greetings,
Chavez