Click here to Skip to main content
15,616,138 members
Articles / Web Development / HTML


45 bookmarked

Entity Framework: Storing Complex Properties as JSON Text in Database

Rate me:
Please Sign up or sign in to vote.
5.00/5 (38 votes)
18 Jan 2017CPOL11 min read
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.


Daily Counts


Weekly Counts


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

Written By
Program Manager Microsoft
Serbia 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.

Comments and Discussions