Databases
StackOverflow2013
Postsdbo
PONHibernate - Add Comment Property to Entities (Store with Join)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONHibernate - Add Comment Property to Entities (Store with Join)
    primarykey
    data
    text
    <p>I have a system where I need to be able to add a Comment field onto Customer and Location models but I cannot touch the schema of the existing tables. However, I can add a Comments table. I have simplified this example. We would like the ability to add this Comment to more models moving forward they all use a Guid as Id.</p> <p>This existing system is a 3rd party system with its own data access layer. </p> <p>We are just starting to get into NHibernate. From what I can tell it looks like a Join map.</p> <p>Example:</p> <pre><code>public class Customer { public Guid Id { get; private set; } public string FirstName { get; private set; } public string LastName { get; private set; } public string Comment { get; set; } } public class Location { public Guid Id { get; private set; } public string Name { get; private set; } public string Address { get; private set; } public string Comment { get; set; } } </code></pre> <p>Note: we are sure we want the Comment as a 1-to-1 relationship and not a 1-to-many.</p> <p>How do I configure a separate table just capture Id and Comment? I'm looking for the right terminology to use. I'm looking for examples with XML (and if possible Fluent config). I would like to keep the Comments for all objects in one table. Thanks.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBuddyJoe
    1. USBuddyJoe
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONHibernate - Add Comment Property to Entities (Store with Join)
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload