Serialize and deserialize json, cannot deserialize the current JSON object

Question

0.00/5 (No votes)

See more:

Hi,

I got error message that I have to deserialize json, so I did:

   var user = db.Users.Select(x => new RegisterBindingModel()
            {
                Id = x.Id,
                Email = x.Email,
                UserName = x.UserName,
                FirstName = x.FirstName,
                LastName = x.LastName,
                Age = x.Age
            });

            var a = user.ToList();
            var b = Json(new { Data = a, Total = a.Count() });
List<RegisterBindingModel> c = 
 JsonConvert.DeserializeObject<List<RegisterBindingModel>>(b.Content);

Which is through an error as json format is incorrect, and I did the following:

 var user = db.Users.Select(x => new RegisterBindingModel()
            {
                Id = x.Id,
                Email = x.Email,
                UserName = x.UserName,
                FirstName = x.FirstName,
                LastName = x.LastName,
                Age = x.Age
            });

            var a = user.ToList();
            var b = Json(new { Data = a, Total = a.Count() });
            string strserialize = JsonConvert.SerializeObject(b.Content);
            //var recordObject = JObject.Parse(b.Content);
            var v = b.Content.ToString();
List<RegisterBindingModel> c = 
JsonConvert.DeserializeObject<List<RegisterBindingModel>>(strserialize);

And I got the first error I faced:
>>

Newtonsoft.Json.JsonSerializationException: 'Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List`1[Project.Models.RegisterBindingModel]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly. To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object. Path 'Data', line 1, position 8.'

Here is json object:

{"Data":[{"Id":1,"Email":"AdminTest@gmail.com","UserName":"AdminTest",
"FirstName":"Admin","LastName":"Test","Age":23}],"Total":13}

What I have tried:

string strserialize = JsonConvert.SerializeObject("["+b.Content+"]");

Which made json format like this:

"[{ Data = System.Collections.Generic.List`1[Project.Models.RegisterBindingModel],
  Total = 13 }]"

I got this error:

Newtonsoft.Json.JsonSerializationException: 'Error converting value "[{ Data = System.Collections.Generic.List`1[Project.Models.RegisterBindingModel],
  Total = 13 }]" to type 
  'System.Collections.Generic.List`1[Project.Models.RegisterBindingModel]'. Path 
  '', line 1, position 97.'

Also tried this:

var c = JsonConvert.DeserializeObject <IDictionary<string, 
  RegisterBindingModel>> (strserialize);

And I got:

Newtonsoft.Json.JsonSerializationException: 'Cannot deserialize the current JSON array (e.g. [1,2,3]) into type 'Project.Models.RegisterBindingModel' because the type requires a JSON object (e.g. {"name":"value"}) to deserialize correctly. To fix this error either change the JSON to a JSON object (e.g. {"name":"value"}) or change the deserialized type to an array or a type that implements a collection interface (e.g. ICollection, IList) like List that can be deserialized from a JSON array. JsonArrayAttribute can also be added to the type to force it to deserialize from a JSON array. Path 'Data', line 1, position 9.'

Posted 29-Apr-19 23:40pm

Member 12919448

Updated 29-Apr-19 23:59pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2019-04-29T23:57:00

You have a list of RegisterBindingModel objects, you then create a new object with a property of Data that points to that list and a Total property, you then try and deserialise that object back to a list. Obviously that's not going to work as the new object isn't a list of RegisterBindingModel, it's an object with a Data property and a Count property. You'll need to create a new object to deserialise the data to

public class MyData
{
    public List<RegisterBindingModel> Data { get; set; }
    public int Total { get; set; }
}

MyData c = JsonConvert.DeserializeObject<MyData>(b.Content);

phil.o · Answer 2 · 2019-04-30T00:00:00

Have you seen and tried Newtonsoft: Serializing Collections[^] already?

Your code is quite confusing because what you are serializing the Content property of the b variable enclosed between square brackets. Try storing this value in a variable, put a breakpoint on that line, and launch a debug session; you will see what is really provided to the Json constructor.

C#

var content = b.Content; // Put a breakpoint on this line
string strserialize = JsonConvert.SerializeObject(content);

You can also watch for the value of the v variable, which you do not seem to use as far as I can see.

Serialize and deserialize json, cannot deserialize the current JSON object

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0