Mapping a property to a field from another table in NHibernate

Question

consider the following class:

class Order {
    int OrderId {get; set;}
    int CustomerId {get; set;}
    string CustomerName {get; set;}
    //other fields go here
}

which is displayed in the order table. Can I map a CustomerName property to a Customers table with a foreign key relationship?

Answer 1

Yes, you can use the join display element for this. Another option is to match the view instead of the table. But, if possible, you should use an object-oriented approach and map the many-to-many relationship between the order and the customer.

Answer 2

<join/> . , , .

. , , order.Customer.Name.

, :

1) Customer Order

public virtual Customer Customer { get; set; }

2) ( CustomerId - FK)

<many-to-one name="Customer" column="CustomerId"/>

3) CustomerName, :

public virtual string CustomerName { get { return Customer.Name; } }