Exception in serialization of System.Data.DataTable using the new "System.Text.Json" class (Asp.net core 3.0 preview 8)

Question

I am writing a rest api in asp.net core 3.0 preview 8 and I was trying to serialize a System.Data.DataTable using the new "System.Text.Json" class, but in the Serialize method I receive the exception:

The collection type 'System.Data.DataRelationCollection' on 'System.Data.DataTable.ChildRelations' is not supported.

The same serialization works well using the newtonsoft json serializer.

Sample code to reproduce the problem:

var dt = new System.Data.DataTable("test");
dt.Columns.Add("Column1");
var ser=System.Text.Json.JsonSerializer.Serialize(dt);

Detailed exception:

System.NotSupportedException HResult=0x80131515 Message=The collection type 'System.Data.DataRelationCollection' on 'System.Data.DataTable.ChildRelations' is not supported. Source=System.Text.Json StackTrace: at System.Text.Json.JsonClassInfo.GetElementType(Type propertyType, Type parentType, MemberInfo memberInfo, JsonSerializerOptions options) at System.Text.Json.JsonClassInfo.CreateProperty(Type declaredPropertyType, Type runtimePropertyType, Type implementedPropertyType, PropertyInfo propertyInfo, Type parentClassType, JsonSerializerOptions options) at System.Text.Json.JsonClassInfo.AddProperty(Type propertyType, PropertyInfo propertyInfo, Type classType, JsonSerializerOptions options) at System.Text.Json.JsonClassInfo..ctor(Type type, JsonSerializerOptions options) at System.Text.Json.JsonSerializerOptions.GetOrAddClass(Type classType) at System.Text.Json.WriteStackFrame.Initialize(Type type, JsonSerializerOptions options) at System.Text.Json.JsonSerializer.WriteCore(Utf8JsonWriter writer, PooledByteBufferWriter output, Object value, Type type, JsonSerializerOptions options) at System.Text.Json.JsonSerializer.WriteCore(PooledByteBufferWriter output, Object value, Type type, JsonSerializerOptions options) at System.Text.Json.JsonSerializer.WriteCoreString(Object value, Type type, JsonSerializerOptions options) at System.Text.Json.JsonSerializer.Serialize[TValue](TValue value, JsonSerializerOptions options) at ErrorJsonMIcrosoftDataTable.Controllers.WeatherForecastController.Get() in G:\testnet\ErrorJsonMIcrosoftDataTable\ErrorJsonMIcrosoftDataTable\Controllers\WeatherForecastController.cs:line 31 at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<g__Logged|12_1>d.MoveNext()

May you kindly help?

Thank you.

In my case, I'd be happy if I could just figure a way to ignore the ChildRelations property. — Auspex
– Auspex, Commented Nov 8, 2019 at 16:05
Do you need to deserialize, or only serialize? Using a JsonConverter, serialization is much easier than deserialization. — dbc
– dbc, Commented Nov 27, 2019 at 5:16
See stackoverflow.com/q/59780446/8479 for a solution using System.Text.Json — Rory
– Rory, Commented Feb 25, 2022 at 19:58

UNOPARATOR · Accepted Answer · 2019-11-09 08:51:48Z

6

Short answer: It can't be done with System.Text.Json, at least for the time being.

If you would like to serialize System.Data.DataTable using ASP.NET Core 3.0 with what is available today, please continue reading the rest of my post for a workaround.

Workaround: First of all, you should check the "Json.NET support" of the "Migrate from ASP.NET Core 2.2 to 3.0" document from MS.

The solution has 2 steps:

Add a package reference to "Microsoft.AspNetCore.Mvc.NewtonsoftJson"
Add this line ".AddNewtonsoftJson()" right after "services.AddMvc()" Here is an example for Startup.cs before & after the change:

Before:

services
    .AddMvc(options =>
    {
        options.EnableEndpointRouting = false;
    })
    .SetCompatibilityVersion(CompatibilityVersion.Version_3_0)
    .AddJsonOptions(options =>
    {
        options.JsonSerializerOptions.IgnoreNullValues = true;
        options.JsonSerializerOptions.WriteIndented = true;
    });

After:

services
    .AddMvc(options =>
    {
        options.EnableEndpointRouting = false;
    })
    .AddNewtonsoftJson()
    .SetCompatibilityVersion(CompatibilityVersion.Version_3_0)
    .AddJsonOptions(options =>
    {
        options.JsonSerializerOptions.IgnoreNullValues = true;
        options.JsonSerializerOptions.WriteIndented = true;
    });

edited Nov 9, 2019 at 8:51

answered Oct 4, 2019 at 9:16

UNOPARATOR

7061 gold badge6 silver badges18 bronze badges

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

2 Comments

Auspex Over a year ago

How is telling the OP to go back to the old JSON serializer (which they obviously already know works), any kind of answer to the question? It's a question about how you can make the new serializer work. If you can't, then the answer is just "it can't be done", not a description of how to use a different serializer

Fabio Pagano Over a year ago

@Unoparator thank you, your sample code helped me so much.

Collectives™ on Stack Overflow

Exception in serialization of System.Data.DataTable using the new "System.Text.Json" class (Asp.net core 3.0 preview 8)

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related