Best DAL Generator?
in [ASP .NET]
|
Prev: Microsoft Office Excel cannot access the file (IIS7)
Next: The Web server does not appear to have FrontPage Server Extensions installed
From: Bobby Edward on 17 Sep 2008 00:20 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.
From: Mark Rae [MVP] on 17 Sep 2008 04:22 "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? For the DAL part, I would recommend this: http://www.microsoft.com/downloads/details.aspx?familyid=4C557C63-708F-4280-8F0C-637481C31718&displaylang=en -- Mark Rae ASP.NET MVP http://www.markrae.net
From: Bobby Edward on 17 Sep 2008 07:56 > > For the DAL part, I would recommend this: > http://www.microsoft.com/downloads/details.aspx?familyid=4C557C63-708F-4280-8F0C-637481C31718&displaylang=en > Thanks. This doesn't auto-generate the DAL though, correct? It just helps you for good, clean, code reuse, etc...
From: Mark Rae [MVP] on 17 Sep 2008 09:08 "Bobby Edward" <bobby(a)nobody.com> wrote in message news:eidzlxLGJHA.3388(a)TK2MSFTNGP02.phx.gbl... >> For the DAL part, I would recommend this: >> http://www.microsoft.com/downloads/details.aspx?familyid=4C557C63-708F-4280-8F0C-637481C31718&displaylang=en >> > > Thanks. This doesn't auto-generate the DAL though, correct? It just > helps you for good, clean, code reuse, etc... I think you're getting confused between a DAL and a BOL... The whole point of a DAL is that, once you've written it, you can simply drop it unchanged into any future development - you don't "auto-generate" it for every new project... -- Mark Rae ASP.NET MVP http://www.markrae.net
From: Cowboy (Gregory A. Beamer) on 17 Sep 2008 09:37
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. > |