/azure-sql-db-dynamic-schema

Samples on how efficiently to handle dynamic schemas in Azure SQL

Primary LanguageC#MIT LicenseMIT

page_type languages products description urlFragment
sample
tsql
sql
csharp
azure-sql-database
azure
dotnet
azure-app-service
Dynamic Schema Management With Azure SQL
dynamic-schema-management-with-azure-sql

Dynamic Schema Management With Azure SQL

License

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:

YouTube recording https://youtu.be/tHBeJIAPr70?t=34