| page_type | languages | products | description | urlFragment | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
sample |
|
|
Dynamic Schema Management With Azure SQL |
dynamic-schema-management-with-azure-sql |
A sample project that shows how to deal with dynamic schema in Azure SQL, using the native JSON support and then three options
- The "Classic" Table
- An Hybrid Table with some well-known columns an "Extension" column to hold arbitrary JSON data
- A full "Document" approach where data is fully stored as JSON document
Detailed explanation of concept and example is available in this recorded session:
https://youtu.be/tHBeJIAPr70?t=34
If you prefer using Entity Framework to access the databasem, you can find the same sample using EF Core in the [https://github.com/Azure-Samples/azure-sql-db-dynamic-schema] repo.