How to substitute storage with Azure CosmosDB?

[xperiandri]

I have the other stuff stored in ComsosDB, so I want CMS data to live there too.
How to achieve that?
What interfaces do I need to implement for that?

[hishamco]

I think you need to add your own DB Provider that extends YesSQL data provider, have a look to SqlServer implementation https://github.com/sebastienros/yessql/tree/main/src/YesSql.Provider.SqlServer

[hishamco]

No need to replace it, you need to inject your custom provider like the default one, but I'm not sure if the AddDataAccess() is extensible to add a new provider instead of rewriting the logic

Waiting for Seb ...

[xperiandri]

@sebastienros any help with this?

[ns8482e]

I guess probably- need to replace ootb contentmanager with new one that do not use yessql

[xperiandri]

Could you point to the code file?

[sebastienros]

Multiple components use YesSql directly and build SQL queries. I don't think this will be possible. You can have some components use something else but you won't be able to replace yessql completely. Not until any data access is actually. One good example of such abstraction is the user management which uses UserStores (from ASP.NET Identity) and could have custom implementations.