Adding Azure Sql Database as an option to store metadatas

[Mimetis]

Idea

Adding an option to add Azure Sql Database as metadata store for Ygdra.Host Web Api.

Today

For now, all the metadatas used by Ygdra.Host and HangFire are stored in a simple CosmosDB database:

The solution is already defined to handle several metadata providers:

And the Ygdra.Host appsetting file contains the definition of the provider used:

  "YProvider": {
    "Provider": "YCosmosDbProvider",
    "Endpoint": "https://XXXXXX.documents.azure.com:443",
    "AccountKey": "vcaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa==",
    "Database": "Ygdra",
    "Container": "Ygdra"
  },

Expectation

Creating the YSqlDatabaseProvider and update the application to be able to use it