SQL Server has allowed JSON columns for a while - now we can access them directly from C# through Entity Framework.

Source code available at: https://github.com/JasperKent/EF7-JSO...

Topics include:
Defining JSON object with ToOne
Defining JSON arrays with ToMany
Querying on JSON properties
The problem of querying JSON arrays
Querying JSON arrays in SQL
Emitting SQL directly in Entity Framework with FromSql
Parameterizing SQL in Entity Framework
Avoiding SQL injection attacks