Entity Framework Core - Knowledge Base (KB)

Newtonsoft JSON serialize list in list

I am using a ef core database in my UWP app and have some issues serializing a list containing a list with Newtonsoft JSON....For a minimal example consider the UWP tutorial from ...microsoft... with the following code...public class Blog { public int...

Self referencing loop from Newtonsoft JsonSerializer using Entity Framework Core

I've encountered the error: ...JsonSerializationException: Self referencing loop detected for property 'Subject' with type 'Project.Models.Subject'. Path 'data[0].Totals'....It occurs when I load a View with a dataGrid populated by an ...IEnumerable<S...

How to store JSON in an entity field with EF Core?

I am creating a reusable library using .NET Core (targeting .NETStandard 1.4) and I am using Entity Framework Core (and new to both). I have an entity class that looks like:...public class Campaign { [Key] public Guid Id { get; set; } [Requi...

How to remove circular reference from entity framework core

Web Api Core, Entity Framework Core...Situation... - Many to many relationship. A, Join, B. Join has Id references to both A and B. A has collection for Joins. B has collection for Joins....Goal... - Get A with Joins with B - and no further....Problem...

Parse JSON Object / Array of Strings into new Custom Class

I'm trying to parse some JSON data and ultimatley store it in a database....I'm having issues when storing a collection of strings / values which are not objects themselves....For example - The "callingCodes" & "altSpellings"...I want to store these in an...

Newtonsoft.Json AttributeProvider does not provide runtime added custom attributes

I did write a model generator to create an interface between client ViewModels and server Models....Some model classes are serialize with ...[JsonObject(MemberSerialization.OptIn)]... attribute and their properties are marked with ...[JsonProperty ...]...

Self Reference when serializing nested Object

I want to store a snapshot of a nested model in my database as sort of a change history. Therefore I made a model that serializes the whole object into a JSON string for easier storage....Simplified ...Data... class I want to store:...public class Data { ...

Entity Framework Core how to list one to many from many to many from a model without using Include().ThenInclude()

I'm creating an ASP.NET Core API with entity framework core and mySQL and i have an issue with listing data from Many to Many tables using ThenInclude(). The data send in JSON keeps referencing relations over relations until it sends over 50kb of data....

How to use AutoMapper to map OData enum string in json request dto to entity enum property

I am working on a new ASP.NET Core 3.1.1 API with Microsoft.AspNetCore.OData v 7.3.0, AutoMapper v9.0.0 and Microsoft.AspNetCore.Mvc.NewtonsoftJson v3.1.1...I am getting the following error when I make a POST to the Accounts endpoint using Postman v7.18.0...