by dan 10/05/06 12:00:00 Article c#.

I'm looking for a good ORM and I'm still waiting for Microsoft WinFS.

Fav Free: NHibernate / MonoRail

Fav Commercial: LLBLGen Pro & maybe WilsonOrm

Monorail

• ActiveRecord, can be used for both WinForm & Web
• based on NHibernate
• poor documentation. Can't figure out how to do many-to-many. Also can't use IList for 1:n relationship since IList is not created.
• want to use boo's brail
• can use it on desktop development.

gentle.net

• oss, needs mygeneration to gen db tables
• very little docs!!!
• attribute based, not XML
• defining relation is weird looking.
• sqlce possible (compilable)

NPersist

• lgpl, xml based, Domain based, kinda hard to read
• full inheritance model
• part of puzzle.net, can use GUI Puzzle

Object Mapper

• MS SQL & Access & Borland Interbase only for now

NHibernate

• java crowd, XML based
• direct competitor to OJB
• can be used under Java/Springs (MVC arch)
• mssql,mysql,access, but no sqlce???
• little/no doc for c# crowd.
• see sample (benday.com's bugtracker src in folder)

ibatis (apache)

• not a true orm, but a data-mapper. Can coexist with nhibernate
• not oo, but relational-based, mapping sql to methods

retina.net

• gotodotnet project
• support?, very limited doc, but seems easy to use
• full inheritance (child/parent model), replaces sysiphus,
• supports sharphsql embedded database (WinCE),
• mysql, mssql, access, postgres, but no SqlCE???

ntiergen

• free, once was commercial
• only MSSQL
• no docs found?

rapiddb

• sqlce support!
• very alpha, but active

doodads -

• free built-in from mygeneration
• no joins!
• easy, simple to code.
• meant to be used as base for full ORM

easyobjects.net

• combo of doodads and MS Enterprise Lib
• only ms-sql (uses stored procedures for db op)
• no joins!

NEO.codehaus.org

• verbose codes (and use of factory pattern)
• domain model
• no entity inheritance,
• little doc

atoms framework

• little documentation, oss
• last update 4/2005