How to compare 2 dynamic lists populated from json?

Question

I have a dynamic JSON which I am deserializing using Newronsoft JSON.

    if (string.IsNullOrEmpty(JsonString) == false)
    {
        DeserializedJson = JsonConvert.DeserializeObject<dynamic>(JsonString);
    }

The Json is an array and one of the node is results. I have 2 lists node1 and node2. 2 exact same Json stirngs coming from different sources are populating these lists with items from results node.

public List<object> node1;
public List<object> node2
int Node1TotalResults = Enumerable.Count(Searchers[0].DeserializedJson.Results);
int Node2TotalResults = Enumerable.Count(Searchers[1].DeserializedJson.Results);
for (int i = 0; i <= (Node1TotalResults - 1); i++)
{
    node1.Add(Searchers[0].DeserializedJson.Results[i]
}
//Same stuff for node2

Now to Compare, I tried 2 different approaches and none of them see to work. But if I print them manually, both lists look similar. Here is how I compared them:

//1st Method:
  if (node1.SequenceEqual(node2))
  {
      result = true;
  }

//2nd Method:
  if(object.Equals(node1, node2))
  {
            result = true;
  }

Both of these methods return false. Any thing here that I can do?

Here is the Sample JSON:
 "Results": [
    {
        "MlsCode": "NON-MLS",
        "MlsAgentId": "45D7D24E253F46A88458B88891E05A1D",
        "UserId": null,
        "FirstName": "Eric",
        "LastName": "Heal",
        "OfficeName": "Nick Salamone Real Estate",
        "MlsOfficeId": "62B8C79E0E0E4D63A7EEF2313BAC98DF",
        "Phones": [
            "3125688028"
        ]
     }
]

I should add, when I convert this json into c# classes and add individual key/item from results array to these lists and compare them using the first method above, it works fine.

What exactly is the type and content of `node1` and `node2`? — dcastro, Jun 03 '15 at 13:58
If you're wanting to check if they are the same, could you not just compare the 2 JSON strings before you convert them to objects? — scgough, Jun 03 '15 at 14:09
So, you have two JSON documents. Each document has a `Results` key, with a corresponding array. And you want to make sure that the arrays from both documents match, is that correct? — dcastro, Jun 03 '15 at 14:09
@scgough I need to pull individual keys/properties from Json. — Atit, Jun 03 '15 at 14:12
possible duplicate of [Object comparison in JavaScript](http://stackoverflow.com/questions/1068834/object-comparison-in-javascript) — Margus, Jun 03 '15 at 14:16

score 1 · Answer 1 · answered Jun 03 '15 at 14:12

1

Use JToken.DeepEquals to compare the two JArrays

string jsonString1 = ...;
string jsonString2 = ...;

var obj1 = JObject.Parse(jsonString1);
var obj2 = JObject.Parse(jsonString2);

var areEqual = JToken.DeepEquals(obj1["Results"], obj2["Results"]);

answered Jun 03 '15 at 14:12

dcastro

66,540
21
145
155

Thanks! I will try this and post the outcome here. – Atit Jun 03 '15 at 14:20

Margus · Answer 2 · 2015-06-03T14:39:00.763

Json :

{
    "Results": [
        {
            "MlsCode": "NON-MLS",
            "MlsAgentId": "45D7D24E253F46A88458B88891E05A1D",
            "UserId": null,
            "FirstName": "Eric",
            "LastName": "Heal",
            "OfficeName": "NickSalamoneRealEstate",
            "MlsOfficeId": "62B8C79E0E0E4D63A7EEF2313BAC98DF",
            "Phones": [
                "3125688028"
            ]
        }
    ]
}

Would results in (Copy + Paste Special > Paste JSON as classes ):

    public class Rootobject
    {
        public Result[] Results { get; set; }
    }

    public class Result
    {
        public string MlsCode { get; set; }
        public string MlsAgentId { get; set; }
        public object UserId { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string OfficeName { get; set; }
        public string MlsOfficeId { get; set; }
        public string[] Phones { get; set; }
    }

To deserialize :

public static class Extensions
{
    public  static bool DeserializeJson<T>(this String str, out T item)
    {
        item = default(T);
        try
        {
            item = new JavaScriptSerializer().Deserialize<T>(str);
            return true;
        }
        catch (Exception ex)
        {
            return false;
        }
    }
}

After that you could write:

var jsonStr = "{\"Results\": [...]}";
Rootobject json;
if(jsonStr.DeserializeJson(out json)){
    //do something with json
}

To answer question. Easiest would be to check 2 objects serialized versions.

Your post explains how to deserialize a JSON string into a structured object - that's not what the OP asked at all. — dcastro, Jun 03 '15 at 14:46

How to compare 2 dynamic lists populated from json?

2 Answers2