Best OR Mapping Tier Code Gen tool

Please could people suggest which OR Middle Tier code gen tool for .NET (VB .NET code) they recommend and have used knowing it to be robust.
Thanks.

http://www.mygenerationsoftware.com/

By far the best ... Check out our dOOdads

I don't think of a code generator as an OR mapper but that is just my opinion (which may not be the same as everyone else's). Most of the good ones are expensive. I found this which mimics the ObjectSpaces (feature in Whidbey that does OR mapping) syntax http://www.ormapper.net/ it works pretty good, really simple.

Not to point out any competition but CodeSmith is another good template code generator.
http://www.ericjsmith.net/codesmith/

No problem at all, we've won over many converts already from CodeSmith. We link to many of our competitors, our goal is to simply help developers, that's why our download is no hassle, no questions asked, and we give it away.

MyGeneration is exactly an OR mapper, and I've looked at object spaces, I would never use them, we were going to support them with our product now have looked more deeply at them we have second thoughts about spending the effort.

What do you find wrong with ObjectSpaces?

Your product looked more like a code template generator to me, is that not correct? At least in my opinion OR mapping isn't about generating code but about handling it all at runtime according to the map. There isn't a whole lot of difference but I think the root of one is different than the other.

I'm also not trying to put your product or you down in anyway just curious.

Sure, first, MyGeneration is an OR mapper, the ability to generate code of course goes without saying. We pull all of the meta data out of your database using our MyMeta API and build your business entities and the stored proc's to create fully functional (more powerful that Object Spaces) objects, ie, we are doing the OR mapping for you. We support Transactions and such as well. However, we can generate all 100 of your business entities in about two seconds, without forcing you to go through the 47 object spaces wizard screens. Of course, what we generate is fully customizable as you can modify the scripts. We can generate stored procedures, business entities, UI screens, html reports, whatever, so we're much more than Object Spaces, and once you use MyGeneration you will constantly use it to remove grunt work from all phases of your project. You can write templates (scripts) in VBScript, JScript, C# Script, and VB.NET Script in MyGeneration.

Look at our dOOdads sample code:
http://www.mygenerationsoftware.com/...tersample.aspx

We can save, delete, load, Query dynamically, use transactions, and give you a better class than does Object Spaces, not to mention that you can fully customize it, fully !!!

And more importantly, we don't make you store your object definitions twice, once in the database and in once in XML. If you change your table you regenerate in two seconds. We also support 5 other databases and can easilly add more. However, you can create business entities that look differently than your database because there is nothing, nothing you cannot do with MyGeneration.

If you look at this article:
http://www.microsoft.com/belux/nl/ms...ectspaces.mspx you can see all of the steps required to play with Object Spaces, and they copy all of the fields out of the datasource and into the object (a waste of time if you only want to access one field).

Compare those features to MyGeneration, we do that better, we do it now, it's free, and that's just the tip of the iceberg, to us the ability to generate a business entity is no big deal.

I think that page is a bad example:

VB Code:

Dim mappath As String = IO.Path.Combine(Application.StartupPath, "NorthwindMap.config")
        Dim cnnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=V:\Practice\TestBed8\bin\NorthWindDemo.mdb;Persist Security Info=False"
        Dim manager As New ObjectSpace(mappath, cnnStr, Provider.Access)
 
        Dim i As Idea = CType(manager.GetObject(GetType(Idea), 1), Idea)

The map file was created via a simple wizard (1 screen) where I choose a datasource. This is actually using the Wilson OR Mapper but it uses the same syntax as ObjectSpaces.

I guess its just a matter of preference but I don't want my classes generated for me (for the most part). I generally work backwards and build my classes and worry about where or how to persist them later. That is why I like the more map oriented approach where it just matches up what I have with my storage and splits out an external item (xml file), but I guess that's just me. Thanks for the info though.

MyGeneration: Please read the Private Message I sent you a few days ago.