Lab 2: Review and upload data
Task 1: Upload images to Azure Blob Storage
In the Azure portal's navigation pane, navigate back to the Storage accounts blade, and then select the polystor[yourname] storage account that you created in this lab's previous exercise.
On the polystor[yourname] storage account blade, select the Containers link in the Data storage section.
In the Containers section, select + Container.
In the New container pop-up window, perform the following actions, and then select Create:
| Setting | Action | | -- | -- | | Name text box | Enter images | | Public access level drop-down list | Select Blob (anonymous read access for blobs only) |
Back in the Containers section, select the newly created images container.
Find the Settings section on the Container blade, and then select the Properties link.
In the Properties pane, note and record the value in the URL text box. You'll use this value later in this lab.
Find and select the Overview link on the blade.
On the blade, select Upload.
In the Upload blob pop-up, perform the following actions:
a. In the Files section, select the Folder icon.
b. In the File Explorer window, browse to $HOME\training-az204\Labs\04\Starter\Images, select all 42 individual .jpg image files, and then select Open.
c. Ensure that Overwrite if files already exist is selected, and then select Upload.
Note: Wait for all blobs to upload before you continue with this lab.
Task 2: Review JSON data
From the lab computer, start Visual Studio Code.
From the File menu, select Open File, browse to $HOME\training-az204\Labs\04\Starter\AdventureWorks\AdventureWorks.Upload, select models.json, and then select Open.
Review the format of the models.json file and note that it contains an array of JSON objects, with a nested array of objects that are part of the Products property.
Note: This will determine the classes you'll define to deserialize the JSON file's contents before uploading it to a Cosmos DB collection.
Within the models.json file, note that one of the properties is named Category.
Note: You'll use the Category property to define partitioning of the target Cosmos DB collection.
Close Visual Studio Code.
Task 3: Create a Cosmos DB database and collection, and perform a JSON data upload
On the Start screen, select the Visual Studio Code tile.
From the File menu, select Open Folder.
In the File Explorer window that opens, browse to $HOME\training-az204\Labs\04\Starter\AdventureWorks, and then select Select Folder.
In the Visual Studio Code window, on the Menu Bar, select Terminal and then select New Terminal.
In the terminal, verify that the current directory is set to AdventureWorks (or change it to that if it's not), and then run the following command to switch your terminal context to the AdventureWorks.Upload folder:
cd .\AdventureWorks.Upload\Note: Before you perform the next step, open Windows Explorer and remove the Read-only attribute from the file $HOME\training-az204\Labs\04\Starter\AdventureWorks\AdventureWorks.Upload\AdventureWorks.Upload.csproj
From the terminal prompt, run the following command to add the Azure Cosmos DB .NET client library to the currently opened project:
dotnet add package Microsoft.Azure.Cosmos --version 3.28.0Note: The dotnet add package command will add the Microsoft.Azure.Cosmos package from NuGet. For more information, refer to Microsoft.Azure.Cosmos.
Observe the results of the build printed in the terminal. The build should complete successfully with no errors or warning messages.
In the Explorer pane of the Visual Studio Code window, expand the AdventureWorks.Upload project.
Open the Program.cs file.
In the Program.cs file, review the using directives and note that they include Microsoft.Azure.Cosmos, System.IO;, System.Text.Json, System.Threading.Tasks, and System.Collections.Generic. This enables asynchronous upload of JSON items from a local file on your lab computer to a collection in a Cosmos DB database.
In the Program.cs file, on line 14, set the value of EndpointUrl by replacing the empty string with the URI property of the Cosmos DB account that you recorded earlier in this lab. Ensure that the value is enclosed in double quotes.
On line 15, set the value of AuthorizationKey by replacing the empty string with the PRIMARY KEY property of the Cosmos DB account that you recorded earlier in this lab. Ensure that the value is enclosed in double quotes.
On line 18, set the value of PartitionKey by replacing the empty string with "/Category".
On line 19, set the value of JsonFilePath by replacing the empty string with "$HOME\\training-az204\\Labs\\04\\Starter\\AdventureWorks\\AdventureWorks.Upload\\models.json".
Within the try block, note the invocation of the CreateDatabaseIfNotExistsAsync method of the CosmosClient class. This will create a database if one doesn't already exist.
Note the invocation of the DefineContainer method of the Database class. This will create a container that will host the JSON items if one doesn't already exist.
Note: The DefineContainer method includes a cost-minimizing option whereby you can modify the default indexing policy (which automatically indexes all attributes).
Note the using statement that relies on a StreamReader object to read JSON items from a text file and deserializes them into objects of the Model class defined further in the Program.cs file.
Note the foreach loop that iterates over the collection of deserialized objects and asynchronously inserts each of them into the target collection.
Review the Model and Product classes that reflect the format of the objects stored in the JSON-formatted file you reviewed earlier in this lab.
Save and close the Program.cs file.
Note: Select Overwrite if you received a prompt that the file is read-only.
In terminal, run the following command to restore any missing NuGet packages and build the project in the folder:
dotnet buildNote: The dotnet build command will automatically restore any missing NuGet packages prior to building all projects in the folder.
From the terminal prompt, run the following command to run the .NET Core console application:
dotnet runNote: The dotnet run command will automatically build any changes to the project and then start the web application without a debugger attached. The command will output the messages indicating the data load's progress, including the number of items inserted into the target collection and the duration of the insert operation.
Observe the results of running the command printed in the terminal. The run should complete successfully, displaying the message about there being 119 items inserted into the target Cosmos DB collection.
Select Kill Terminal (the Recycle Bin icon) to close the terminal pane and any associated processes.
Task 4: Validate JSON data upload
On your lab computer, switch to the Microsoft Edge browser window displaying the Azure portal.
In the Azure portal, select the Search resources, services, and docs text box, in the Recent resources list, select the polycosmos[yourname] Azure Cosmos DB account that you created earlier in this lab.
On the Azure Cosmos DB account blade, find and select the Data Explorer link on the blade.
In the Data Explorer pane, expand the Retail database node.
Expand the Online container node, and then select New SQL Query.
Note: The label for this option might be hidden. You can display labels by hovering over the icons in the Data Explorer pane.
On the query tab, enter the following text:
SELECT * FROM modelsSelect Execute Query, and then observe the list of JSON items returned by the query.
Back in the query editor, replace the existing text with the following text:
SELECT VALUE COUNT(1) FROM modelsSelect Execute Query, and then observe the result of the COUNT aggregate operation.
Switch back to the Visual Studio Code window.
Review
In this exercise, you used the .NET SDK for Azure Cosmos DB to insert data into Azure Cosmos DB. The web application that you implement next will use this data.