Monday 9 January 2023

Azure Cosmo DB

 Azure Cosmo DB used to store non Sql data that is collection of objects.

Important key stack properties are id and partition key.

Partition Key is kind of grouping / or like disk drive C, D drive in our PC,Lap.

Make sure partition key as perfect column Ex: need to retrieve data frequently day wise means then i will make CreatedDate as partition key (CreatedDate= DateTime.UtcNow.Date) 

id: its mandatory property & non-nullable

Unique/Primary key: will be combination of Partition Key + id

we can insert same id again but it's partition should be different. also, we can store different type of object but that object should contain same id and partition key.

Hierarchy: Example based OrderGroups is container


-->Data Base 

    |__ Container: kind of table or entity name

            |__ Items: Kind of Table Entity values

            |__Stored Procedure

            |__User Defined Functions & Stored Procedure

            |__ Triggers