I have to describe interconnection between objects.
public class Entity
{
public string Name {get;set;}
public IList<Entity> Connections {get;set;}
}
How can i persist this?
I add another layer of complexity: querying on a specific date a connection between two entities can't be already defined. So probably I need a support table that contain a structure like Id, Source, Destination, ValidFrom, ValidUntil
Mauro