Which ORM to use?
Posted
by Paja
on Stack Overflow
See other posts from Stack Overflow
or by Paja
Published on 2010-04-25T18:24:46Z
Indexed on
2010/04/25
18:43 UTC
Read the original article
Hit count: 288
I'm developing an application which will have these classes:
class Shortcut
{
public string Name { get; }
public IList<Trigger> Triggers { get; }
public IList<Action> Actions { get; }
}
class Trigger
{
public string Name { get; }
}
class Action
{
public string Name { get; }
}
And I will have 20+ more classes, which will derive from Trigger
or Action
, so in the end, I will have one Shortcut
class, 15 Action
-derived classes and 5 Trigger
-derived classes.
My question is, which ORM will best suit this application? EF
, NH
, SubSonic
, or maybe something else (Linq2SQL
)?
I will be periodically releasing new application versions, adding more triggers and actions (or changing current triggers/actions), so I will have to update database schema as well. I don't know if EF
or NH
provides any good methods to easily update the schema. Or if they do, is there any tutorial how to do that?
I've already found this article about NH
schema updating, quoting:
Fortunately NHibernate provides us the possibility to update an existing schema, that is NHibernate creates an update script which can the be applied to the database.
I've never found how to actually generate the update script, so I can't tell NH
to update the schema. Maybe I've misread something, I just didn't found it.
Last note: If you suggest EF
, will be EF
1.0 suitable as well? I would rather use some older .NET than 4.0.
© Stack Overflow or respective owner