Self referencing loop Entity FrameWork

Question

I'm currently using WebApi 2.0 and EntityFrameWork and I'm having issues with it:

Self referencing loop detected for property 'UserInfo' with type 'System.Data.Entity.DynamicProxies.UserInfo_F7C6DF3909A804C5A9AC107297C8851F4CC9DF1CCA4A689B892B6C6EBA5A6EA8'. Path '[0].User'."

my DB is something like this: User-UserInfo and is 1-1 relationship, the PK of User is the PF in UserInfo;

public class User {    
        public int UserId { set; get; }
        public string username { set; get; }
        public string password { set; get; }
        public string name { set; get; }
        public string email { set; get; }
        public string surname { set; get; }
        public string lastName { set; get; }
        public int age { set; get; }
        public DateTime regDate { set; get; }
        public bool userType { set; get; }

        //we define our relationships
        //1-1 UserModel-UserInfo
        public virtual UserInfo UserInfo { set; get; }
}

My UserInfo class:

public class UserInfo { 
    [Key, ForeignKey("User")]
    public int UserId { set; get; }        
    public string username { set; get; }        
    public string phone{ set; get; }        
    public string adress { set; get; }        
    public string country { set; get; }        
    public string city { set; get; }        
    public string zip { set; get; }

    //we define our relationships 
    //1-1 UserModel-UserInfo
    public virtual User User { set; get; }

}

In Postman I send a Post request and register a user:

{
  "username": "otmanlicona",
  "password": "pwd1234",
  "name": "Otman",
  "email": "[email protected]",
  "surname": "licona",
  "lastName": "ledezma",
  "age": 33,
  "regDate": "2017-03-01T18:10:11+00:00",
  "userType": false
}

If I send a GET request I get all the users:

[
  {
    "Orders": [],
    "ReviewProducts": [],
    "UserInfo": null,
    "UserId": 7,
    "username": "otmanlicona",
    "password": "pwd1234",
    "name": "Otman",
    "email": "[email protected]",
    "surname": "licona",
    "lastName": "ledezma",
    "age": 33,
    "regDate": "2017-03-01T12:10:11",
    "userType": false
  },
  {
    "Orders": [],
    "ReviewProducts": [],
    "UserInfo": null,
    "UserId": 8,
    "username": "angelsilva",
    "password": "pwd1234",
    "name": "angel",
    "email": "[email protected]",
    "surname": "silva",
    "lastName": "borja",
    "age": 22,
    "regDate": "2017-03-01T12:10:11",
    "userType": true
  }
]

No problems so far , the problem is when I insert the UserInfo:

{
  "UserId": 8,
  "username": "angelsilva",
  "phone": "12345678",
  "adress": "550 Swallow Hill",
  "country": "USA",
  "city": "foo",
  "zip": "47-253"
}

If I send another GET request I get an Exception: Image of the error

Self referencing loop detected for property 'UserInfo'

Can anyone tell me what I'm doing wrong?,Thanks

[
  {
    "Orders": [],
    "ReviewProducts": [],
    "UserInfo": null,
    "UserId": 7,
    "username": "otmanlicona",
    "password": "pwd1234",
    "name": "Otman",
    "email": "[email protected]",
    "surname": "licona",
    "lastName": "ledezma",
    "age": 33,
    "regDate": "2017-03-01T12:10:11",
    "userType": false
  },
  {
    "Orders": [],
    "ReviewProducts": [],
    "UserInfo": {
      "UserId": 8,
      "username": "angelsilva",
      "phone": "12345678",
      "adress": "550 Swallow Hill",
      "country": "USA",
      "city": "foo",
      "zip": "47-253"
    },
    "UserId": 8,
    "username": "angelsilva",
    "password": "pwd1234",
    "name": "angel",
    "email": "[email protected]",
    "surname": "silva",
    "lastName": "borja",
    "age": 22,
    "regDate": "2017-03-01T12:10:11",
    "userType": true
  }
]

NOW I see what does Entity Framework meant by self referencing loop; What can I do so in my Get response only returns me the other values that aren't in the User Class like username,phone,address,country, etc.

Most likely nobody has any idea what you're doing wrong, you have not provided any code to that produces an exception. How to create a Minimal, Complete and Verifiable example. — Erik Philips
– Erik Philips, Commented Mar 2, 2017 at 18:21
Instead of adding the found solution to the question, accept Yashveer's answer. — user47589
– user47589, Commented Mar 2, 2017 at 18:51
Now that I found the solution , I came with another question, Do I have to ask another question or append it to this? — Angel Silva
– Angel Silva, Commented Mar 2, 2017 at 18:54

Yashveer Singh · Accepted Answer · 2017-03-02 18:20:56Z

3

try this on startup .cs 

 config.Formatters.JsonFormatter.SerializerSettings.ReferenceLoopHandling 
= Newtonsoft.Json.ReferenceLoopHandling.Ignore;

answered Mar 2, 2017 at 18:20

Yashveer Singh

2,0072 gold badges18 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Angel Silva Over a year ago

thanks I resolve the issue with: GlobalConfiguration.Configuration.Formatters.JsonFormatter.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore; Which is basically the same thing

Yashveer Singh Over a year ago

@AngelSilva great

user4864425 Over a year ago

Though this solves your issue, consider using DTO's instead.

Adrian Mole · Accepted Answer · 2023-09-25 08:03:10Z

0

Try this:

JsonSerializerSettings settings = new JsonSerializerSettings(); 

settings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;

 var Serializedata =JsonConvert.SerializeObject(data,settings);

edited Sep 25, 2023 at 8:03

Adrian Mole

52.1k193 gold badges61 silver badges101 bronze badges

answered Sep 23, 2023 at 12:41

Mahdi Gheysari

11 bronze badge

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Self referencing loop Entity FrameWork

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related