Hi
I'm using Fluent Nhibernate, i need to create mappings for 2 tables:
Simplified, they look like this:
TAXI
(
Id int primary key
Name varchar
)
ORDER
(
Id int primary key
RedirectedFrom int foreign key on TAXI.Id
RedirectedTo int foreign key on TAXI.Id
)
So, two foreign keys from table TAXI refer to table ORDER
Q:
Is that a kind of many-to-many relation and its necessary to create a link table OrderTaxi?
Or it is possible to work with it as many-to-one? would be great to show bidirectional and unidirectional mapping then