Okay, so we know how to map all of the basic fields now, but what about those pesky Foreign Key fields, such as BillToContact_Id? How do we map those guys? They're mapped as int
in the database, so we can just map them as int
or Integer
, right?
Technically, we could map them as int
in our code, but that would make our work much more difficult when we go to use the actual object, and the reason we are using NHibernate is to make our job EASIER!
What we really need to do is map these fields as objects. As each of these fields links to another table (BillToContact_Id stores the ID from Contact) we can map these fields as objects and actually view these related objects.
For example, the OrderItem table has a parent-child relationship to the OrderHeader table using the field OrderHeader_Id, which links this table to the OrderHeader table. If I was looking at an order (OrderHeader), I would want to see all the items on that order (OrderItem). If I want to look at all the...