/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
dotnet-core
azure-web-app
Real-Time Serverless GeoSpatial Public Transportation GeoFencing Solution
azure-sql-db-serverless-geospatial

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