tags:

views:

67

answers:

0
Q: 

NHibernate non normalized database design

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? We don't have the option to modify the existing DB design.

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

related questions

How to keep track of the references to an object?
When should you use 'friend' in C++?
Overiding the equals method vs creating a new method
Making one interface overwrite a method it inherits from another interface in PHP
What are the correct stencils for object relational diagramming in visio?
Is Single Responsibility Principle a rule of OOP?
Expression Evaluation and Tree Walking using polymorphism? (ala Steve Yegge)
Access to global application settings
Inheritance and Polymorphism - Ease of use vs Purity
Do you name controls on forms using the same convention as a private variable?
How do you create a static class in C++?
How do you create objects in Perl?
Why all the Active Record hate?
When is OOP better suited for?
Accessing a CONST attribute of series of Classes
Multi-Paradigm Languages
Speed Comparisons - Procedural vs. OO in interpreted languages
pass by reference or pass by value?
How to Think in OO
Using object property as default for method property
Adding a Method to an Existing Object
Object Oriented vs Relational Databases
Class views in Django
C++: Should I use nested classes in this case?
How would you access Object properties from within an object method?