Convert MongoDB Json to C# Class

Question

I've result from MongoDB called by "mongoDBResult"

[{
    "_id": {
        "$oid": "57e8e914c2ef164375bc0957"
    },
    "user": "456"
},
{
    "_id": {
        "$oid": "57e8ea87bd966f3e6de5361b"
    },
    "user": "admin"
}]

And my Class define

public class Id
{
    public string oid { get; set; }
}

public class User
{       
    public Id _id { get; set; }
    public string user { get; set; }
}

But when i use JsonConvert.DeserializeObject like this :

var user = JsonConvert.DeserializeObject<List<User>>(mongoDBResult);

I can get value of user name , and i want to get value of Id.oid but still always null

Anyone can help me how to convert from MongoDB to C# Class with perfect way ?

BWA · Accepted Answer · 2016-09-26 09:48:01Z

3

Your problem is here:

JOSN:

"$oid": "57e8e914c2ef164375bc0957"

CODE:

public string oid { get; set; }

In JSON you have $oid in code oid

You can try:

[JsonProperty(PropertyName = "$oid")]
public string oid { get; set; }

Or you can change JSON, if you can.

edited Sep 26, 2016 at 9:48

answered Sep 26, 2016 at 9:45

BWA

5,7748 gold badges39 silver badges49 bronze badges

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

2 Comments

BWA Over a year ago

@EddyLee I'm glad that I helped. Mark reply as an answer ;-)

mybirthname Over a year ago

@EddyLee if the answer helped you, mark as correct.

Bharat · Accepted Answer · 2016-09-26 09:44:11Z

0

Try below code.

 Test routes_list = 
      (Test)json_serializer.DeserializeObject("{ \"test\":\"some data\" }");

answered Sep 26, 2016 at 9:44

Bharat

2,4643 gold badges28 silver badges37 bronze badges

1 Comment

EddyLee Over a year ago

var user = (List<User>)JsonConvert.DeserializeObject<List<User>>(mongoDBResult); => still get null at Id.oid

Collectives™ on Stack Overflow

Convert MongoDB Json to C# Class

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related