What I did there is to break entities out of the tables using view, so instead of working against that schema, we have a much nicer model to work against.
Saving is tricky, but most of the data is read only. It is triggers and cheating when it is not possible.
The end result is three tiers of the data:
- Real database - really ugly and not easy to work with
- Views database - makes sense if you look at it from afar
- OR/M (NHib) - Gives a reasonable way to work with the system.
The problem in this is that sometimes I need to cheat on all three levels to get something to work.
But it is working, and we get very good results out of it.
On 6/12/06,
hammett <[EMAIL PROTECTED]> wrote:
I'm in a kind similar situation. I didn't use AR nor NHibernate at
all. Anyway, you might want to spike it for a while before making a
decision.
On 6/12/06, Craig Neuwirt <[EMAIL PROTECTED]> wrote:
> However, the existing app uses a set
> of tables that do not represent the domain AT ALL. Stored Procedures are
> used to access and update the tables. Eventually, I will replace the
> database schema, but for now I need to live with it. As such, I would like
> to use ActiveRecord in my controllers. Is this possible? Can ActiveRecord
> interact with the database in a custom way?
--
Cheers,
hammett
http://hammett.castleproject.org/
_______________________________________________
CastleProject-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/castleproject-users
_______________________________________________ CastleProject-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/castleproject-users
