writing to json refactor code

Question

I am writing results i return from stored procedure into json. I did it but i am not sure if there is a simpler cleaner way other than what i have. Also how can i check that it really wrote to json?

var results = mySvc.GetInfo("Environment");

StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
JsonWriter jsonWriter = new JsonTextWriter(sw);
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName("Id");
jsonWriter.WriteValue(results.Id);
jsonWriter.WritePropertyName("Head");
jsonWriter.WriteValue(results.Head);
jsonWriter.WritePropertyName("Value");
jsonWriter.WriteValue(results.Value);
jsonWriter.WritePropertyName("GuidTwo");
jsonWriter.WriteValue(results.GuidTwo);
jsonWriter.WritePropertyName("GuidOne");
jsonWriter.WriteValue(results.Guid1);
jsonWriter.WriteEndObject();
return results;

To expand on @janisz suggestion : msdn.microsoft.com/en-us/library/bb412179.aspx — Jason Evans
– Jason Evans, Commented Aug 6, 2013 at 13:08

Trevor Pilley · Accepted Answer · 2013-08-06 13:27:34Z

4

Install Json.NET and you simply do this:

var results = mySvc.GetInfo("Environment");
var json = JsonConvert.SerializeObject(results);

The inverse:

var results = JsonConvert.DeserializeObject<Result>(json);

edited Aug 6, 2013 at 13:27

answered Aug 6, 2013 at 13:13

Trevor Pilley

16.5k6 gold badges47 silver badges61 bronze badges

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

3 Comments

Masriyah Over a year ago

this worked nicely - now if i want to get the info from json in a different method how could i extract from this?

Masriyah Over a year ago

Where did <Result> come from?

Trevor Pilley Over a year ago

Result is the class that the data is deserialised into. In your case, it will be whatever type is returned by mySvc.GetInfo()

zzzzBov · Accepted Answer · 2013-08-06 13:18:14Z

2

try this

var results = mySvc.GetInfo("Environment");
var js = new System.Web.Script.Serialization.JavaScriptSerializer();
var jsonObj = js.Serialize(results);

edited Aug 6, 2013 at 13:18

zzzzBov

180k57 gold badges328 silver badges375 bronze badges

answered Aug 6, 2013 at 13:08

sangram parmar

8,7862 gold badges26 silver badges48 bronze badges

1 Comment

Masriyah Over a year ago

what namespace is serialization under?

James Kyburz · Accepted Answer · 2013-08-06 13:23:27Z

2

By using ServiceStack json serializer(it's faster than the json.net)

 Install-Package ServiceStack.Text
 using ServiceStack.Text;

 var json = results.ToJson();

answered Aug 6, 2013 at 13:23

James Kyburz

14.6k1 gold badge34 silver badges33 bronze badges

3 Comments

Masriyah Over a year ago

and if i would like to extract information from Json - how will that look?

James Kyburz Over a year ago

What is to consume the json?

James Kyburz Over a year ago

@Masriyah Without using another class type to serialize to and from you can use JsonSerializer.DeserializeFromString<Dictionary<string, object>>(json); //not the best solution however with all the casting you'll need to do. - there must be a better way...

Collectives™ on Stack Overflow

writing to json refactor code

3 Answers 3

3 Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related