Geek Answers Handbook

Is it possible to use Cosmos database instead of Azure SQL DATABASE?

I am very pleased to use the Cosmos database in my current application instead of the Azure SQL database.

Before using Cosmos DB as a backend in my current application, I have a few questions, in my opinion, this

  • In my current application, I used the Entity framework.
  • And also column encryption, dynamic data masking functions are used.

So, if I switched to the Cosmos database instead of using the Azure SQL database, then how can I achieve these capabilities with the Cosmos database?

The documentation does not contain details about encryption, masking, and entity infrastructure.

Could you tell me: "Can I use the Cosmos database with the above requirements instead of the Azure SQL database?

+5
source share
1 answer

Entity Framework is specific to relational databases, so it does not fit the Cosmos DB document repository (or graphics or tables).

As for encryption: Cosmos DB provides encryption at rest, built-in. There is no built-in built-in data masking function. you will need to do your own data masking.

If you go to a document repository (or a graph or a table), it really depends on you, and whether you want to reformat your data in accordance with such a storage model, as well as with a relational model. There is no real way to answer this question. (TL; DR, you cannot just switch from relational to, say, a document, without any changes, since these are fundamentally different storage concepts).

+9
source

More articles:


All Articles