Hi all,

We have the following Database design.
As you can see, there is non normalized between the main tables
("ACCOUNTS" and "CONTACTS") with "NOTES".

How we can get a collection of "Notes" for the 2 main tables based on
this DB design within NHibernate?

ACCOUNTS (considered 1)
AcountID int
AccountNo text

CONTACTS (considered 2)
ContactID int
ContactName text

NOTES
NoteID int
EntityID int (1: ACCOUNTS, 2: CONTACTS)
EntityRowID int (An AcountID or ContactID)
Note text

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to