I have been messing around with a few O/R Mappers. As of now, I still am not in favor of them, but I want to at least get them KINDA working right.
Mostly the big problem I am having is w/ nulls. You can't have a null integer.
The 2 I have been using are
Wilson ORMapper and
NHibernate.
This page shows some sample code for Wilson, and
this apge is the documentation for NHibernate, with their forms being located
here.
In
this blog entry Wilson claims that his handles nulls, but I haven't seen how to do that yet.