Sign in to confirm you’re not a bot
This helps protect our community. Learn more

.NET Data Community Standup - JSON Columns

dotnet
324K subscribers
<__slot-el>
<__slot-el>
8.8K views Streamed 2 years ago
In this episode of the .NET Data Community Standup, join Arthur Vickers (@ajcvickers) and the .NET Data team to learn about mapping to JSON columns in EF Core 7.0 (EF7). JSON columns allow relational databases to directly store documents while retaining the overall relational structure of the data. EF7 contains provider-agnostic support for JSON columns, with an implementation for SQL Server. The JSON in these columns can queried using LINQ, allowing filtering and sorting by the elements of the documents, as well as projection of elements out of the documents into results. In addition, EF7 supports element-level change tracking of the documents and partial updates for only the changed elements when SaveChanges is called. Featuring: Arthur Vickers @ajcvickers, Jiachen Jiang @jiachenjiang_ ...more
...more

Annotations for Aggressive Trimming

4:03

Aggressive Trimming

5:14

Debugging into Framework Core Migration Scaffolding and Execution

9:25

Json Columns

12:24

Why Would You Even Want To Use Json in Your in Your Relational Databases

17:37

Denormalization

21:19

Composite Foreign Key

25:43

Data Annotation

29:52

Table Sharing

36:21

Composite Types

37:20

Disable Logging

44:03

Sql Server Json Optimizations

44:35

Computed Property

45:02

Map It to a Computed Property

45:33

Drill into the Json Document

51:02

Projections

1:03:11

Json Query

1:05:01

Updates

1:05:57

Value Converters to and from Multiple Database Columns

1:13:48
.NET Data Community Standup - JSON Columns
In this episode of the .NET Data Community Standup, join Arthur Vickers (@ajcvickers) and the .NET Data team to learn about mapping to JSON columns in EF Core 7.0 (EF7). JSON columns allow relational databases to directly store documents while retaining the overall relational structure of the data. EF7 contains provider-agnostic support for JSON columns, with an implementation for SQL Server. The JSON in these columns can queried using LINQ, allowing filtering and sorting by the elements of the documents, as well as projection of elements out of the documents into results. In addition, EF7 supports element-level change tracking of the documents and partial updates for only the changed elements when SaveChanges is called. Featuring: Arthur Vickers @ajcvickers, Jiachen Jiang @jiachenjiang_

Follow along using the transcript.

dotnet

324K subscribers