C#•3y ago

❔ Serializing related object EF

Hello all,

I have 2 models

public class City {
    [Key]
    public int Id { get; set; }
    [Required]
    public string Name { get; set; }
    [Required]
    public string CountryName { get; set; }
    public Coordinates? Coordinates { get; set; }
}

public class Coordinates {
    public int Id { get; set; }
    public double X { get; set; }
    public double Y { get; set; }
    public int CityId { get; set; }
    public City City { get; set; } = null!;
}

public class City {
    [Key]
    public int Id { get; set; }
    [Required]
    public string Name { get; set; }
    [Required]
    public string CountryName { get; set; }
    public Coordinates? Coordinates { get; set; }
}

public class Coordinates {
    public int Id { get; set; }
    public double X { get; set; }
    public double Y { get; set; }
    public int CityId { get; set; }
    public City City { get; set; } = null!;
}

public class City {
    [Key]
    public int Id { get; set; }
    [Required]
    public string Name { get; set; }
    [Required]
    public string CountryName { get; set; }
    public Coordinates? Coordinates { get; set; }
}

public class Coordinates {
    public int Id { get; set; }
    public double X { get; set; }
    public double Y { get; set; }
    public int CityId { get; set; }
    public City City { get; set; } = null!;
}

public class City {
    [Key]
    public int Id { get; set; }
    [Required]
    public string Name { get; set; }
    [Required]
    public string CountryName { get; set; }
    public Coordinates? Coordinates { get; set; }
}

public class Coordinates {
    public int Id { get; set; }
    public double X { get; set; }
    public double Y { get; set; }
    public int CityId { get; set; }
    public City City { get; set; } = null!;
}

And I would like to include

Coordinates

Coordinates

Coordinates

Coordinates of

City

City

City

City in my response however I get error

JsonException: A possible object cycle was detected. This can either be due to a cycle or if the object depth is larger than the maximum allowed depth of 64

JsonException: A possible object cycle was detected. This can either be due to a cycle or if the object depth is larger than the maximum allowed depth of 64

JsonException: A possible object cycle was detected. This can either be due to a cycle or if the object depth is larger than the maximum allowed depth of 64

JsonException: A possible object cycle was detected. This can either be due to a cycle or if the object depth is larger than the maximum allowed depth of 64

My query is

return db.Cities
        .Where(c => c.Name.ToLower().Contains(city.ToLower()))
        .Include(c => c.Coordinates)
        .ToList();

return db.Cities
        .Where(c => c.Name.ToLower().Contains(city.ToLower()))
        .Include(c => c.Coordinates)
        .ToList();

return db.Cities
        .Where(c => c.Name.ToLower().Contains(city.ToLower()))
        .Include(c => c.Coordinates)
        .ToList();

return db.Cities
        .Where(c => c.Name.ToLower().Contains(city.ToLower()))
        .Include(c => c.Coordinates)
        .ToList();

I have googled it and found different approaches but from the examples I saw, this should be working.

Why does this happen?

❔ Serializing related object EF

Similar Threads

Similar Threads

Similar Threads