Comparison Between Two database-driven code generators (nettiers 2.0 vs subsonic)

The following is a reference from someone on a forum.

Nettiers 2.0 (codesmith) vs subsonic

. Nettiers is not free. It used to be free, but then Eric J. Smith changed his pricing model and yanked the free version out from under the Community that made codesmith a booming product.

In my opinion, codesmith had the perfect model. there was a free part, the generator, that everyone cocould use. you cocould Build templates on your own, and use the generator, and everyone was excited. then, there was a paid for add on that was the IDE that wocould allow you to Build templates much easier. perfect. you have a free part, that help build a community, and you had a pay part, that cocould be a revenue stream.

then, after the Community was established, and lots of people began seeing how powerful the tool cocould be, they all started pitching in templates and contributing to the community. and, then, the free part of the app was taken away. kind of an underhanded move, in my opinon. and, thats just my opinion. if it was never free, nobody wowould have even bothered with codesmith. nobody wocould have contr Ibuted to the community which actually made that product, and. nettiers wouldnt be what it is today. you wouldnt see marketing posts like this (How many times does it say. nettiers is free ?), And you definitely wouldnt see things like "join the codesmith revolution" on the codesmith home page. Can I understand why the move was made? Sure, for the money. Do I think it was underhanded? Absolutely.

Back on topic... as for a comparison of Subsonic and. nettiers (which the title of this thread made me think was in here), here are some of my impressions. please keep in mind that these tests were using timers and were on my workstation with the webserver and sqlserver running locally. if you dont agree with these results, or question the integrity, feel free to run your own tests.

• For raw queries (select column1, column2, columnn from Table), nettiers seems to be faster than subsonic by an average of 8/1000ths of a second for my tests, which basically consisted of getting all the rows out of the Products table in northwind.
• Subsonic has dynamic queries on the client, where nettiers uses the same generic code for top, paged, and whatever other dynamic stuff it needs to do (order by and special where clses ). the subsonic queries are more specific to the task, and are generally faster than the same query on. nettiers, again, we are talking in the 1000ths of seconds in my not-so-scientific tests.
• Subsonic can only do paging on sql2005, where nettiers can do it anywhere. Hopefully, that wont always be the case.
• Nettiers generates 5.82 MB in 457 files in 34 folders for northwind. Enterprise Library and all its terrabytes of references in your bin folder.

• Subsonic generate 272 kb in 30 files in 1 folder for northwind. subsonic. dll in your bin folder.

• Web. config changes: A Couple Of unintrusive lines for subsonic, and, well, weve all seen the entlib web. config changes. even if the entlib stuff is in an external file, there are still more changes in the web. config than subsonic.

• . nettiers is far more mature than subsonic. its Configuration over Convention attitude makes for a much more solid generation base. I mean, it supports multi-column primary keys, better guid support, associative table queries, a domain model or service layer, and has way more eyes looking at it getting bugs identified and fixed.

• subsonic is free .. nettiers templates are free, but the template processor is not free . its like saying Microsoft Word documents are free, but Microsoft Word is not.

• Nettiers service layer is great. Subsonic probably wont ever do this because that doesnt seem to be the scope of the product.

• Deep load/deep save are implemented much better in. nettiers.

• Rules and validation features baked in to. nettiers seem to be cool, but I havent used them enough to speak to them.

• . Nettiers overall architecture is superb.

• . nettiers is huge. its output is huge and its a lot to wade through, shocould you ever want to dig into some of the Entity objects.

• . nettiers is not as flexible as subsonic. it is very easy to get a count of items in a database with subsonic, and its kind of indirect on how you do it. nettiers.

• Subsonic is better for database independence. I know the entlib was supposed to do this for us, and it does in your cases. Its just easier to do in subsonic.

Anyway, those are just some of my observations. If you dont like it, or dont agree with it, please feel free to do your own research and post your findings. Jesse foster | jf26028

In my opinion, subsonic is more lightweight than ntiers. Dynamic generation of SQL is a highlight because it is an open-source project andCodeThe structure is very simple, so it is easy to make some special modifications at the code layer. Ntier is more profound, so I don't know whether it is good or not. ntiers is more reliable in terms of stability. In particular, ntiers can be used with some templates to generate data source packages that support ASP. net2.0. The template Code has the taste of ASP. Neter and emphasizes the universality of Some architectures.

Http://actionpack.wekeroad.com/forums/post/1517.aspx

Http://www.nettiers.com/Download.aspx

Http://www.codeplex.com/actionpack