For local Cloud site clones when LocalDB is not available, we don't automatically use SQLite

[nul800sebastiaan]

This leads to jobs not being added and the dashboard in the backoffice gives a 404 error.

To avoid this problem a connection string can be added to appsettings.Development.json

    "ConnectionStrings": {
        "umbracoDbDSN": "Data Source=|DataDirectory|/Umbraco.sqlite.db;Cache=Private;Foreign Keys=True;Pooling=True",
        "umbracoDbDSN_ProviderName": "Microsoft.Data.SQLite"
    },

We'll need to do some auto-detecting if we can!

[firomero]

I received
Unhandled exception. System.ArgumentException: Keyword not supported: 'cache'.