What’s the best way to jSON serialize a .NET DataTable in WCF?

by

  1. DataTable is a pure .NET construct which cannot be (easily) represented in a lossless manner by JSON. DataTables contain lots of additional information which JSON cannot store: Primary keys, autoincs, allow nulls, caption, data type, indexes, etc. Serialization to XML/Binary are the only ways a DataTable can be serialized natively by .NET. This XML serialized DataTable is then serialized to JSON.

  2. Use JSON.NET or FastJSON to convert a DataTable to a plain, clean JSON-compatible version of the DataTable, which can be consumed by any JSON client, not just .NET WCF clients. You will lose all DataTable custom properties mentioned in (1) above and only get the field name/value JSON pair. Storage in this fashion is inefficient due to the duplication of field names in every row.

Don’t use DataTable in your DataContract. If you want the benefits of a DataTable and your clients are always going to be .NET, serialize the DataTable to a byte array via Binary Serialization and then optionally compress the resultant serialized byte stream. Expose a byte array in your DataContract. This will give you an efficient, fully lossless version of the DataTable on the client-side (after decompression and binary deserialization), not a watered-down JSON version of a DataTable (as offered by (2))…

More Related Contents:

  1. replace WCF built-in JavascriptSerializer with Newtonsoft Json.Net json serializer
  2. How to localize when JSON-serializing?
  3. How to deserialize a JObject to .NET object
  4. How do I use JSON.NET to deserialize into nested/recursive Dictionary and List?
  5. How to deserialize an array of values with a fixed schema to a strongly typed data class?
  6. Detect if deserialized object is missing a field with the JsonConvert class in Json.NET
  7. Can Json.NET serialize / deserialize to / from a stream?
  8. Using Json.NET converters to deserialize properties
  9. How to serialize/deserialize a custom collection with additional properties using Json.Net
  10. Custom Deserialization using Json.NET
  11. Ensuring json keys are lowercase in .NET
  12. Does .NET 4 have a built-in JSON serializer/deserializer?
  13. Generate C# classes from JSON Schema [closed]
  14. Json.NET serializing float/double with minimal decimal places, i.e. no redundant “.0”?
  15. Cannot deserialize JSON array into type – Json.NET
  16. How to apply indenting serialization only to some properties?
  17. Ignoring null fields in Json.net
  18. Any way to make DataContractJsonSerializer serialize Dictionaries properly?
  19. JSON.NET JsonConvert vs .NET JavaScriptSerializer [closed]
  20. Get Raw json string in Newtonsoft.Json Library
  21. Custom WCF DataContractSerializer
  22. How to remove k__BackingField from json when Deserialize
  23. WCF Disable Deserialization Order Sensitivity
  24. Deserializing JSON into an object with Json.NET
  25. JSON serialization of array with polymorphic objects
  26. Casting interfaces for deserialization in JSON.NET
  27. What are the deficiencies of the built-in BinaryFormatter based .Net serialization?
  28. Send JSON via POST in C# and Receive the JSON returned?
  29. WCF error: The caller was not authenticated by the service
  30. WCF is using the computer name instead of the IP address and cannot be resolved

Leave a Comment