Entity Framework: Storing Complex Properties as JSON Text in Database

Jovan Popovic(MSFT)

Rate me:

5.00/5 (38 votes)

18 Jan 2017CPOL11 min read

168.1K

Mapping properties in EF model to database columns that contain JSON

Complex properties in entity Framework models such as arrays, dictionaries, and objects can be serialized in SQL Server database in JSON format. In this article, I will show you how to map your properties in EF model to database columns that contain JSON.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Jovan Popovic(MSFT)

Program Manager Microsoft

Serbia

Graduated from Faculty of Electrical Engineering, Department of Computer Techniques and Informatics, University of Belgrade, Serbia.
Currently working in Microsoft as Program Manager on SQL Server product.
Member of JQuery community - created few popular plugins (four popular JQuery DataTables add-ins and loadJSON template engine).
Interests: Web and databases, Software engineering process(estimation and standardization), mobile and business intelligence platforms.

Entity Framework: Storing Complex Properties as JSON Text in Database

Views

Downloads

License

Comments and Discussions