This is my issue.  The views will most definitely span multiple tables.  The existing data model is so horrific, I can't describe it. 
 
- No surrogate PK, all business related
- Tons of Composite PK (3-5 columns)
- PKs with negative values to indicate business rule
- No foreign keys to determine relationships (plain columns are used)
 
....

 
On 6/13/06, G. Richard Bellamy <[EMAIL PROTECTED]> wrote:

Craig,

 

As far as NH is concerned, it's a table. So, if the update or insert statement that NH creates would work in your favorite query analyzer, it'll work for NH.

 

The real trick comes when the view spans multiple tables, and does not include fields that must have values, and have no defaults, things like that…

 

- Richard

 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ] On Behalf Of Craig Neuwirt
Sent: Monday, June 12, 2006 12:07 PM


To: [email protected]
Subject: Re: [Castle-users] Using ActiveRecord with Legacy Database

 

I would like to use NHib on top of Views, but how will NHibernate work when the data needs to be inserted or updated?




_______________________________________________
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

Reply via email to