Store Data in data base.

How to store this data in data base

{"customEntityId":106,"title":"Test","model":{"shortDescription":"Test","thumbnailImageAssetId":3,"categoryIds":[7],"categoryId":7,"testCheckboxList3":null,"thumbnailImageAssets":[3],"testHtml":"

Test

","testDocumentId":1,"pageId":13,"pageDirectoryId":3,"pageIds":null},"publish":true,"customEntityDefinitionCode":"SIMBLP"}

I have use this but not working

Dictionary empsAndNumbers =
JsonConvert.DeserializeObject>(jsonString);

This error display

{"Could not convert string to integer: Test. Path 'title', line 1, position 36."}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
As per your JSON response, you need to create classes as shown below
public class Model
{
    public string shortDescription { get; set; }
    public int thumbnailImageAssetId { get; set; }
    public List<int> categoryIds { get; set; }
    public int categoryId { get; set; }
    public object testCheckboxList3 { get; set; }
    public List<int> thumbnailImageAssets { get; set; }
    public string testHtml { get; set; }
    public int testDocumentId { get; set; }
    public int pageId { get; set; }
    public int pageDirectoryId { get; set; }
    public object pageIds { get; set; }
}

public class Root
{
    public int customEntityId { get; set; }
    public string title { get; set; }
    public Model model { get; set; }
    public bool publish { get; set; }
    public string customEntityDefinitionCode { get; set; }
}
now, deserialize the JSON and loop through the result, and insert it into the database
Root myDeserializedClass = JsonConvert.DeserializeObject(myJsonResponse);
Salman Beg5y ago
First you used Dictionary and while deserializing you are passing jsonString. But in your jsonString it contains string value and while deserializing it is throwing error. So your jsonString contains string, int value or either change the dictionary. Thanks