Support multiple backend stores

[ffma-glen-sampson]

tightly coupling to CosmosDB is not ideal

[llxu1]

Thank you for reaching out @ffma-glen-sampson. CosmosDB is used for both the adapter metadata store and the distributed cache.
For the metadata store, we provide IAdapterResourceStore interface, which allows you to implement a custom storage provider for storing metadata. We also offer an in-memory store implementation there.
For distributed caching, you can refer to this guide on various implementation options in ASP.NET Core: Distributed caching in ASP.NET Core. You may replace the CosmosDB cache with a different provider based on your requirements.
Could you let us know which storage option you're looking for? We may consider supporting it in a future release.

[bbartels]

Ideally something like postgres would be ideal such that it would allow for straight-forward deployment on-premise!

[JaredMSFT]

HI @llxu1 @bbartels @ffma-glen-sampson I've submitted a PR which uses the Distributed Store interface and included Postgres as an example. Please check it out!