How to implement OneToOne Unidirectional when revers has foreign key

[Chaminda Amarasinghe]

Hi Falks,

I think this question would be a vary common situation.

Lets say I have an existing db tables as follows,

employees
----------
id(PK)
 
cubicles
----------
id(PK)
employee >> (FK to employees)

But I want an OOP implementation as inverse of relational. That means Employee refers to an instance of Cubicle but Cubical has no reference to Employee.

public Employee {
private Cubicle assignedCubicle;
// Getters & Setters
}
 
public  Cubicle {
 
// No Reference to Employee
}

How can I achieve this? (I dont want bidirectional relationship)

Open to discuss.

Thanks

[Sergio Tridente]

You can't.

[Chaminda Amarasinghe]

Very Bad