Streaming large list of data as JSON format using Json.net

by

Assuming your final output is a JSON array and each “chunk” is one item in that array, you could try something like the following JsonStreamingResult class. It uses a JsonTextWriter to write the JSON to the output stream, and uses a JObject as a means to serialize each item individually before writing it to the writer. You could pass the JsonStreamingResult an IEnumerable implementation which can read items individually from your data source so that you don’t have them all in memory at once. I haven’t tested this extensively, but it should get you going in the right direction.

public class JsonStreamingResult : ActionResult
{
    private IEnumerable itemsToSerialize;

    public JsonStreamingResult(IEnumerable itemsToSerialize)
    {
        this.itemsToSerialize = itemsToSerialize;
    }

    public override void ExecuteResult(ControllerContext context)
    {
        var response = context.HttpContext.Response;
        response.ContentType = "application/json";
        response.ContentEncoding = Encoding.UTF8;

        JsonSerializer serializer = new JsonSerializer();

        using (StreamWriter sw = new StreamWriter(response.OutputStream))
        using (JsonTextWriter writer = new JsonTextWriter(sw))
        {
            writer.WriteStartArray();
            foreach (object item in itemsToSerialize)
            {
                JObject obj = JObject.FromObject(item, serializer);
                obj.WriteTo(writer);
                writer.Flush();
            }
            writer.WriteEndArray();
        }
    }
}

More Related Contents:

  1. Convert Json String to C# Object List
  2. JSON Deserialization – String Is Automatically Converted To Int
  3. c# asp.net delete last comma [closed]
  4. Cannot deserialize the JSON array (e.g. [1,2,3]) into type ‘ ‘ because type requires JSON object (e.g. {“name”:”value”}) to deserialize correctly
  5. Detect if deserialized object is missing a field with the JsonConvert class in Json.NET
  6. Json.net serialize/deserialize derived types?
  7. How can I deserialize a child object with dynamic (numeric) key names?
  8. Setting the default JSON serializer in ASP.NET MVC
  9. Deserializing JSON when sometimes array and sometimes object
  10. Cannot deserialize the current JSON object (e.g. {“name”:”value”}) into type ‘System.Collections.Generic.List`1
  11. How to ignore JsonProperty(PropertyName = “someName”) when serializing json?
  12. Deserializing JSON when key values are unknown
  13. Deserializing dates with dd/MM/yyyy format using Json.Net
  14. Deserializing JSON with unknown object names
  15. How to convert datatable to json string using json.net?
  16. How do I convert an escaped JSON string within a JSON object?
  17. JToken: Get raw/original JSON value
  18. JContainer, JObject, JToken and Linq confusion
  19. How to convert Json array to list of objects in c#
  20. Replace part of a JSON with other (using a string token)
  21. Cannot deserialize the current JSON array (e.g. [1,2,3])
  22. Repeated serialization and deserialization creates duplicate items
  23. How do you Add or Update a JProperty Value in a JObject
  24. Load multiple concatenated JSON objects from stream
  25. Parsing a JSON array using Json.Net
  26. Best ways to split a string with matching curly braces
  27. Json.net deserialization null guid case
  28. Deserialize JSON when a value can be an object or an empty array
  29. Is there a way in Json.NET serialization to distinguish between “null because not present” and “null because null”?
  30. Json.net serialization of custom collection implementing IEnumerable

Leave a Comment