Cyclic reference issue ?

Hi !

First I would like to thank you for writing this extension which is really useful for me.

I create a topic because I don't really understand your example and I have the feeling that something goes wrong in the building of my architecture. You give the following code

public class Stock
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }
    [MaxLength(8)]
    public string Symbol { get; set; }

    [OneToMany(CascadeOperations = CascadeOperation.All)]      // One to many relationship with Valuation
    public List<Valuation> Valuations { get; set; }
}

public class Valuation
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }

    [ForeignKey(typeof(Stock))]     // Specify the foreign key
    public int StockId { get; set; }
    public DateTime Time { get; set; }
    public decimal Price { get; set; }

    [ManyToOne]      // Many to one relationship with Stock
    public Stock Stock { get; set; }
}

So if I create a stock then I have a list of Valuation but a Valuation have a reference to Stock and stock have a list of Valuation and so on...

Is it not a cyclic reference?

I created some objects and when I get an object with GetWithChildren() I have in my debugger an endless list of: ObjectA -> list of ObjectB -> ObjectA -> and so on...

So I'm a little afraid about this and I wonder if it was normal?

Comments (6)