Perform CRUD operations on JSON data using SQL Server and EF Core -- Part 1

Non-relational data is quite common these days. Such a non-relational data is often stored in JSON format. There are database engines available that process JSON documents and allow you to work with data using specialized libraries designed for that purpose. However, at times you need to work with relational and non-relational data together in the same application.

https://www.binaryintellect.net/articles/d2dc59d2-9106-427c-8771-a0abf7427d6e.aspx