DocumentDB - Data Types

JSON or JavaScript Object Notation is a pghtweight text-based open standard designed for human-readable data interchange and also easy for machines to parse and generate. JSON is at the heart of DocumentDB. We transmit JSON over the wire, we store JSON as JSON, and we index the JSON tree allowing queries on the full JSON document.

JSON format supports the following data types −

Let’s take a look at a simple example DateTime type. Add birth date to the customer class.

pubpc class Customer {
   [JsonProperty(PropertyName = "id")] 
   pubpc string Id { get; set; }
	
   // Must be nullable, unless generating unique values for new customers on cpent  
   [JsonProperty(PropertyName = "name")] 
   pubpc string Name { get; set; }  
	
   [JsonProperty(PropertyName = "address")] 
   pubpc Address Address { get; set; }  
	
   [JsonProperty(PropertyName = "birthDate")] 
   pubpc DateTime BirthDate { get; set; } 
}

We can store, retrieve, and query using DateTime as shown in the following code.

private async static Task CreateDocuments(DocumentCpent cpent) {
   Console.WriteLine(); 
   Console.WriteLine("**** Create Documents ****"); 
   Console.WriteLine();
	
   var document3Definition = new Customer { 
      Id = "1001", 
      Name = "Luke Andrew", 
		
      Address = new Address { 
         AddressType = "Main Office", 
         AddressLine1 = "123 Main Street", 
         Location = new Location {
            City = "Brooklyn",
            StateProvinceName = "New York" 
         }, 
         PostalCode = "11229",
         CountryRegionName = "United States" 
      },
		
      BirthDate = DateTime.Parse(DateTime.Today.ToString()), 
   };
	
   Document document3 = await CreateDocument(cpent, document3Definition); 
   Console.WriteLine("Created document {0} from typed object", document3.Id); 
   Console.WriteLine(); 
}

When the above code is compiled and executed, and the document is created, you will see that birth date is added now.

**** Create Documents ****  
Created new document: 1001 
{ 
   "id": "1001", 
   "name": "Luke Andrew", 
   "address": { 
      "addressType": "Main Office", 
      "addressLine1": "123 Main Street", 
      "location": { 
         "city": "Brooklyn", 
         "stateProvinceName": "New York" 
      }, 
      "postalCode": "11229", 
      "countryRegionName": "United States" 
   }, 
   "birthDate": "2015-12-14T00:00:00", 
   "_rid": "Ic8LAMEUVgAKAAAAAAAAAA==", 
   "_ts": 1450113676, 
   "_self": "dbs/Ic8LAA==/colls/Ic8LAMEUVgA=/docs/Ic8LAMEUVgAKAAAAAAAAAA==/", 
   "_etag": ""00002d00-0000-0000-0000-566efa8c0000"", 
   "_attachments": "attachments/" 
} 
Created document 1001 from typed object