Some of the posts in the ObjectSpaces MSN newsgroup look pretty interesting :-)

Btw, the correct term is 'O/R mappers', not ORM :). ORM is Object Role Modelling which is a NIAM successor, or in other words, an abstract database modelling technique (and IMHO the best there is). See http://www.orm.net . :)

Point taken ...

Bob.NET? Who is so stupid to call his product Bob.net :-)

(story: the EntityBroke was once named BoB - Business Object Broker. Someone pointed me to Microsoft BOB - and asked me whether I want to have the same name, and within two hours it became EntityObjectBroker, then EntityBroker)

BTW - you should take these out that are NOT O/R mappers or are dead / unborn (going to slashdot and finding "no files released" is no ta sign for an O/R mapper that is available).

And the comments about ORM are right - this is the wrong term. ORM is really NOT the abbreviation for O/R mappers.

Nice list Yves, btw check the asp.net forums on O/R mapping. Besides the bashing of each others products is superb info on the subject.

Also Check out KickStarter, one of the best ive seen so far.

Advanced non intrusive object relational mapping for .NET. Supports inheritance, 1:1, 1:n, n:m, associations mappings and much more. Remotable with application server, integrates security, etc..

I knew it looked to good to be true; I just got this email after I had a question about the product:

Objectz.NET is no longer officially supported by Mongoose Solutions with the
exception of the Mongoose Solutions Forums, which provide peer-to-peer
support for Objectz.NET. There are no future release versions planned for
Objectz.NET at this time.

For this reason, Mongoose Solutions has made the source code for Objectz.NET
available for purchase, and recommends that all customers requiring
customization/issue resolution/feature additions, etc purchase the source
code package in order to make these modifications in-house.


Amos VanHorn
Director, E-Services
Mongoose Solutions, Inc.
http://www.mongoosesolutions.com

I have just released the ALPHA version of this new free, open source O/R mapper.
It has a very nice feature list and an interesting architecture.

If you like, take a look at the GotDotNet workspace.

Best regards,

Andrés G Vettori

Ping Back来自：blog.csdn.net

PingBack from http://serviciipeweb.ro/iafblog/2007/04/26/From+Journeyman+To+Master+90+Din+Ceea+Ce+Trebuie+Sa+Stie+Un+Programator.aspx

You really should give SubSonic a try. It's free/open source, and really rocks the boat right now. It's got a good dev team and is in active development.

www.subsonicproject.com

Hello,

This is a nice list of O/R mapping tools.

But I'm pretty sure one of the best is not presented here.

It is ECO (Enterprise Core Objects). Its successor is Bold for Delphi.

Now it's one of the most powerful Frameworks for .NET (in my opinion and from my experience).

For those who is interested have a look at:

http://dnagir.blogspot.com/

New company is funded to maintain this framework:

http://capableobjects.com/

I hope it will be soon available for Visual Studio developers.

The note: it is not only O/R mapping Framework. It much larger and much powerful. O/R is only one part of it.

Cheers.

Excuse me please. I see it on the list :)

Sorry.

I'm trying to find out the best O/R mapping tool for .NET. A perfect tool would begin with the database model and would be capable of generating 2 layers: the Domain layer (normal classes) and the Persistence layer (methods for storing and retrieving the domain layer objects from the database.

This tool would also be capable of generating the corresponding Visual Studio solution and projects.

I've already tried NetTiers, but it generates so many layers that the code is very dificult to manage and understand.

So any of you know a tool similar to this?

This one is probably the best: en.wikipedia.org/.../CodeGear_ECO

Miguel,

Diamond Binding has the full Visual Studio integration you are after, and it follows the Active Record pattern.

Cheers,

jlx

Please add Persistor.NET® to your list. (www.persistor.net)

Thanks

Hans-Peter

GURA is a new breed of object relational mapper

Ask yourself: Does your O/RM:

Support multiple objects to multiple tables in multiple databases

Not rely on an intermediate query language i.e. OQL but support the FULL range of functions in Microsoft's SQL/Stored Procedures

Is totally legacy system friendly and is just as easily implemented into new or existing applications

Does not produce a single line of code (either source or binary)

Is only 250KB in size

The answer is no as no other O/RM comes close to the power, clever design and ease of use that is GURA.

Try it at www.gura.com.au

Automatic Blog N Ping Script. Create more exposure for your blogs and websites. Full script, easy to install. www.cyberincomesolutions.com/.../index.htm

hi all

my 5 cents ;)

open source, easy to start & use asp.net ORM lib

support native SQL no stupid pseudo SQL syntax ;)

some docs, demo and sources at

www.codeplex.com/easypersist

Thanks!

This .Net solution is completely free, capable, and transparent. Feedback is appreciated.

Sorry, that url was:

www.codeplex.com/jeremydotnet

ORM - Should we move to ORM instead of keep up with conventional DAL ?

I totally agree with u. Thanks for such a good suggestion.

.........

Amara

Wow, check out this site called <a href="www.fluc.com">www.fluc.com</a>

. Free SMS and free mobile ads!! Its fantastic

I use VS 2008, C#, and Telerik controls.  I'm seeking to make a wise decision on an OR/M to ease the pain of the backend "data stuff" whilst adhering to development of "proper" n-layer design.

My research so far has me down to:

- LLBLGen Pro

- Opf3

- EntitySpaces

- SubSonic.

I'm also aware of the existence of a term called "Entity Framework" by Microsoft.  Same goes for LINQ.  I've used a "hint" of LINQ so far.

Can anyone shed light on their experience / knowledge of one or more of these tools?  Any advice you have I would appreciate, even if it's not in this list.

My goal is to select a path which will serve me in the long-term (e.g. I don't want to invest my time and project code to a particular solution only to have it / its company dissolve in two years).

Your input is valuable and much appreciated.

Thank you for your efforts.  I look forward to your feedback.

ECO has moved to http://www.capableobjects.com

Pete

Kuwait’ s investment fund, the Kuwait Investment Authority, or KIA, was founded in 1953, making it one of the oldest sovereign funds in the Middle East, if not the world. It manages an estimated 225 billion worth of assets and, because of falling prices

I use schematrix schemacoder.

www.schematrix.com/.../default.aspx

This generate the code clean and easy.

Opf3 is also missing :)

ECO is at www.capableobjects.com - not codegear / embarcadero etc.

Telerik OpenAccess ORM (formerly Vanatec OpenAccess)

http://www.telerik.com/orm