Share via

Dynamic Schema Management With Azure SQL

Browse code

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

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.