I'm in the process of choosing a O/R mapper for a c# .net/SQL Server project that I will be working on and wanted to see what you guys opinion was. I've used LLBLGEN extensively in the past but since this is a personal project I don't have the money for
it. Has anyone here used a free one that is good?
-
-
Maybe you should check out Scott Hanselman's podcast episode on "Code Generation":
http://www.hanselminutes.com/default.aspx?showID=20
They are discussing quite a few code gen tools (commercial and free ones). -
sbc
GW R/Me
I use MyGeneration to generate dOOdads objects. Supports many databases, plus can generate code for other frameworks (like NHibernate, Gentle.NET and DotNetNuke) and you can even write your own templates with an ASP-like syntax (using VB, JScript, VB.NET or C#). Templates can be given a UI for data input (textboxes, dropdowns, checkboxes etc) - you can even use Windows.Forms to design the UI (if the inbuilt UI tools are not enough).
It is freeware (not open source). I've used it for years now with no problems (bar a few minor bugs that were quickly fixed). There are a lot of positive comments on a recent Code Project Survey: Which .NET data-tier generator do you use? -
littleguru
<3 Seattle
Opf3. It is not free but very low price. - Designed for .NET 2.0
- supports nullable types
- SQL pass through
- simple object query for simple queries
- a lot interface (for own extensions), events, base classes
- comes with wizard that converts the database schema to persistent objects
- was mentioned in the mysterious ADO.NET 3.0 video (they talked about a class named "ObjectContext", which is Opf3's major class)
- supports generics (of course)...
- supports a lot databases: MS SQL Server 2005, MS SQL Server 2000/and above, Oracle, Access, VistaDB, Pervasive SQL, PostgreSQL, MySQL, Firebird.
- comes with sources (when buying it)
(and a few other guys from different companies)
See also here -
Many would say if you have to us an O/R mapper than you might have a serious design issue, but I say to them what happens when the database(s) isnt in your control (90% of the time)?
These "Best Practices" mentioned in all these books everywhere tend to bleed the mind of real world cases dont you think?
Its almost as bad as when programmers use ternary expressions, GOD I HATE THOSE THINGS!! type if out for god sakes!!
-
I would recommend Express Persistent Objects (XPO) from Devexpress. I have used it in a smaller project som time ago, and I liked it quite a lot. It's affordable, their support is very good and bugs you report get corrected very fast.
-
Check out OR.NET - it's absolutely free, and works with .NET 2.0. O/R Mapper I must admit that I am a bit biased here since I wrote it, and have been using it quite a bit
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.