From: Bobby Edward on
Thanks for a great response!

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld(a)comcast.netNoSpamM> wrote in
message news:utfubqMGJHA.2252(a)TK2MSFTNGP02.phx.gbl...
> LLBLGen, which you mentioned, supports MySQL. It is one of my favorite O/R
> Mappers. I also am fond of Genome (www.genom-e.com), but I am not sure if
> it supports MySQL or not. Deklarit also supports MySQL. These are all high
> end generators that produce great code.
>
> TierDeveloper also supports MySQL (I have not tried it, but I have played
> around with their NCache product, which is solid).
>
> If you like to stick with Open Source, NHibernate is an option, although
> it is not particularly aimed at MySQL. Here is a blog entry:
> http://geekswithblogs.net/pariam/archive/2006/07/26/86352.aspx
>
> If you can template your map on one table, CodeSmith should be flexible
> enough to work with. As Mark has alluded to, you can use any DAL you
> desire with your objects and a templated code generator works nicely for
> this. There are schema providers for MySQL for CodeSmith (Google search),
> although they are older. I have used .NET Tiers with CodeSmith in the
> past. It does not fit my current work, but may work for you.
>
> Here is a post where the person used Wilson O/R Mapper with MySQL:
> http://forums.mysql.com/read.php?38,11958,11958
>
> I have never tried this one, but it also supports MySQL out of the box:
> http://www.vanatec.com/en
>
> --
> Gregory A. Beamer
> MVP, MCP: +I, SE, SD, DBA
>
> Subscribe to my blog
> http://feeds.feedburner.com/GregoryBeamer#
>
> or just read it:
> http://feeds.feedburner.com/GregoryBeamer
>
> ********************************************
> | Think outside the box! |
> ********************************************
> "Bobby Edward" <bobby(a)nobody.com> wrote in message
> news:epnunyHGJHA.6052(a)TK2MSFTNGP04.phx.gbl...
>> I've been researching ORM/Tier/DAL code generators.
>>
>> What do you recommend?
>>
>> It seems that subsonic (free) and LLBLGen Pro (paid) are the most
>> popular.
>>
>> Any suggestions?
>>
>> I would prefer that it works with MySQL as well as VB.NET. Also, being
>> able to see/edit the generated code is a plus.
>>
>