Database

Most areas have their own (Azure Sql) database, mostly hosted together in a elastic pool.

• Services query the databases through stored procedures.
• Any change to the database tables, indexes, stored procedures or static configuration data are handled by the .Db project, in the form of database migration scripts.
• To do a change to the database tables, indexes etc add a new sql script to the .Db project. Remember to set build action to "Embedded Resource", otherwise the script wont be picked up when the migration runs in the release pipeline.