Just to play devils advocate,
We recently stripped out all the OR mapping out of our project ,
NHibernate , as it was consuming more time to write the complex hsql queries
and debug the strange behavior of Lazy loading, than it would be to write
straight SQL.
We did keep NHibernate for the login / profile database but replaced for
the referential which was an existing database and much more complex than
NHibernate can handle easily .
The referential database we used Microsoft Application Block ( Data ) + cut
down SQL > Object mapping using Attributes and a bit of refflection.
The small ammounts of updates that we do have, the Update / Insert procedure
is read from an attribute attached to the class and called automatically, if
the column decoration does not exist it tries to map direct to the propery
name on the class.
Example:
[Table("authors")]
[Update("sp_updateAuthors")]
public class Author {
[PrimaryKey("au_id")]
public int Id {}
[Column("au_lname")]
public string LastName{}
}
--
Dave Jones
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
