convert from SqlDataReader to JSON

by

If you want something that’ll convert to arbitrary JSON, you could convert by serializing it into a Dictionary(Of string, object) thusly:

public IEnumerable<Dictionary<string, object>> Serialize(SqlDataReader reader)
{
    var results = new List<Dictionary<string, object>>();
    var cols = new List<string>();
    for (var i = 0; i < reader.FieldCount; i++) 
        cols.Add(reader.GetName(i));

    while (reader.Read()) 
        results.Add(SerializeRow(cols, reader));

    return results;
}
private Dictionary<string, object> SerializeRow(IEnumerable<string> cols, 
                                                SqlDataReader reader) {
    var result = new Dictionary<string, object>();
    foreach (var col in cols) 
        result.Add(col, reader[col]);
    return result;
}

And then use the NewtonSoft.Json JsonConvert object to get your JSON:

var r = Serialize(reader);
string json = JsonConvert.SerializeObject(r, Formatting.Indented);

UPDATE:
If you just want to use built-in methods, and you happen to be using MVC, you can use the built in Json helper method on your newly serialized :

JsonResult Index(int id) {
    var r = Serialize(reader);
    return Json(r, JsonRequestBehavior.AllowGet);
}

More Related Contents:

  1. Deserialize JSON into C# dynamic object?
  2. Does Json.NET cache types’ serialization information?
  3. How to write a JSON file in C#?
  4. Parse Json string in C#
  5. How do I deserialize a complex JSON object in C# .NET?
  6. Convert json to a C# array?
  7. Not ableTo Serialize Dictionary with Complex key using Json.net
  8. How to tell Json.Net globally to apply the StringEnumConverter to all enums
  9. How can I serialize/deserialize a dictionary with custom keys using Json.Net?
  10. What is the difference between PreserveReferencesHandling and ReferenceLoopHandling in Json.Net?
  11. How to call JsonConvert.DeserializeObject and disable a JsonConverter applied to a base type via [JsonConverter]?
  12. HttpClient not supporting PostAsJsonAsync method C#
  13. Newtonsoft JSON dynamic property name
  14. Read and Write file on streamingAssetsPath
  15. Iterating over JSON object in C#
  16. Deserialize JSON to anonymous object
  17. Find and return JSON differences using newtonsoft in C#?
  18. How to convert XML to JSON using C#/LINQ?
  19. Ignoring null fields in Json.net
  20. How can I tell Json.NET to ignore properties in a 3rd-party object?
  21. Why are all the collections in my POCO are null when deserializing some valid json with the .NET Newtonsoft.Json component
  22. Using Custom WCF Body Deserialization without changing URI Template Deserialization
  23. Json.Net PopulateObject – update list elements based on ID
  24. ASP.NET Core 3.0 [FromBody] string content returns “The JSON value could not be converted to System.String.”
  25. How to serialize or deserialize a JSON Object to a certain depth in C#?
  26. Deserializing JSON into an object with Json.NET
  27. Ignore Base Class Properties in Json.NET Serialization
  28. json add new object to existing json file C#
  29. Location of Application.persistentDataPath in a build
  30. Json.net serialization of custom collection implementing IEnumerable

Leave a Comment