Tim linked to a discussion on David Burkes blog about using Paul Wilson's O/R Mapper in a distributed environment. In this, Paul said:
"which in the end brings you back to the fact that distributed systems are not 'hard' but there are a lot of choices"
I certainly aggree that there are a lot of choices, but the only product I've found so far that is not hard is Alex's Base4 - which is not an O/R Mapper - but can be used to achieve the same result.
Maybe I need to have yet another look at Paul Wilson's mapper (which I will have to do soon for a small side project :) but my feeling is that if this was simple, I'd be doing it already.
I need to start working to my mantra - 'less is more, simple is better'. To me O/R Mappers are a stop gap measure until somebody comes up with a real OO solution that provides all of the distributed functionality I require in an easy to use package. So far, Base4 is the closest things I've found. deKlarit is another option that I've used in the past and it does come a lot closer to the ideal solution for me, but again, it's not simple and requires a large time investment to learn.
Maybe this stuff is never going to be simple enough for me?