Json Stream in Wcf c# service to array

Question

I'm really bad with C# and would like your help doing the following; I am currently passing a Json Array to my WCF webservice. I need to take the json array and insert it into a list. I have no idea to deserialize in C#. Please suggest to me what is the best way of achieving this. My code looks as follows:

  public String UpdateOrderAddress(Stream userInfo)
  {
        try
        {               
           StreamReader reader = new StreamReader(userInfo);
           string JSONdata = reader.ReadToEnd();
           if (JSONdata == null)
           {                    
                return "null";
           }                        

           return JSONdata;     // Success !
        }
        catch (Exception e)
        {
            return e.ToString();
        }
  }

This is the data in the string that I get from the reader

[{"date":"2013-02-22 15:30:374:021","id":"1","description":"test","name":"test"},
"date":"2013-02-25 11:56:926:020","id":"2","description":"ghy","name":"fhh"},
"date":"2013-02-25 11:56:248:026","id":"3","description":"ghfm","name":"run"}]

here is a sample : http://stackoverflow.com/questions/7895105/json-deserialize-c-sharp — Zaki, Feb 26 '13 at 14:32

Icarus · Accepted Answer · 2013-02-26T15:37:33.857

The code you posted doesn't show how are you trying to deserialize your json string so I don't really follow what's the relevance here but in any case, this is how to deserialize JSON into a concrete C# class.

Create a class that matches the structure of your Javascript objects as so:

public class Data
{
  public string  Date {get;set;}
  public int ID {get;set;}
  public string Description {get;set;}
  public string Name {get;set;}
}

Deserialize it using the JavascriptSerializer as so:

var deserializedData = new JavaScriptSerializer().Deserialize<List<Data>>(jsonString);

Note that your original JSON string is incorrectly formatted. It's missing the opening { on each element of the array. It should really be:

[{"date":"2013-02-22 15:30:374:021","id":"1","description":"test","name":"test"}, {"date":"2013-02-25 11:56:926:020","id":"2","description":"ghy","name":"fhh"}, {"date":"2013-02-25 11:56:248:026","id":"3","description":"ghfm","name":"run"}]

Now, if you attempt to deserialize the above, as so:

string json = @"[{""date"":""2013-02-22 15:30:374:021"",""id"":""1"",""description"":""test"",""name"":""test""},
   {""date"":""2013-02-25 11:56:926:020"",""id"":""2"",""description"":""ghy"",""name"":""fhh""},
   {""date"":""2013-02-25 11:56:248:026"",""id"":""3"",""description"":""ghfm"",""name"":""run""}]";

var deserializedData = new JavaScriptSerializer().Deserialize<List<Data>>(json);

You'll get a nice List<Data> back.

Also note that I didn't use a DateTime field for the corresponding date field in your Javascript object, the reason being that your sample dates are not valid DateTimes or at least a DateTime object cannot be created from that string representation. For instance, "15:30:374:021" makes no sense - I would imagine that 374 is the seconds field...

You need to add a reference to System.Web.Extensions to be able to use the JavascriptSerializer.

score 0 · Answer 2 · answered Feb 26 '13 at 14:52

You can create a representative class with your required properties to hold the values and use the JavascriptSerializer class. Call the Deserialize<T> method specifying your type to deserialize the JSON into your code.

Links in class names for reference.

Saro Taşciyan · Answer 3 · 2013-02-26T17:36:42.753

0

You can use Newtonsoft.Json Library. All you will need to do is:

List<YourClass> yourClassList = JsonConvert.DeserializeObject<List<YourClass>>(JSONdata);

You find more information, even samples here

edited Feb 26 '13 at 17:36

answered Feb 26 '13 at 14:56

Saro Taşciyan

5,210
5
31
50

Json Stream in Wcf c# service to array

3 Answers3