Contoso Video uploaded a recent test build of their online video store and related projects. This has already been deployed to a web app running in your classroom Azure subscription. You can use this source code as a reference for determining query patterns and business logic. You will need Visual Studio or Visual Studio Code running on a Windows machine with .NET Framework 4.7.2 in order to run it locally. Running it locally is optional, but could make the code evaluation process easier.

• Visual Studio solution

Contoso Video has provided a database document for their current (test) Movies database. Each table contains a brief description and detailed schema information.

• SQL database documentation
• Database diagram

We have provided a data generator that simulates orders from the website and pumps them into Azure Event Hubs. You will use this generator in some of the challenges, but it is a good idea to configure it beforehand. The data generator is deployed as a .NET Core 3.0 self-contained deployment (SCD) package. This means that the .NET Core runtime is included within each platform folder, so you do not need to download the .NET Core 3.0 SDK as a pre-requisite.

1. Download the zip file and extract it to your desktop.

2. Open the folder containing the extracted files, then open either the linux-x64, osx-x64, or win-x64 subfolder, based on your environment.

3. Within the appropriate subfolder, open the appsettings.json file and update it with the following:

   • EVENT_HUB_1_CONNECTION_STRING: Open the Event Hubs namespace in the location 1 resource group (default name is openhack1), open the telemetry event hub, create a new shared access policy with both Send and Listen policies, and paste its connection string here.
   • EVENT_HUB_2_CONNECTION_STRING: Keep empty for now. This will need to be populated in a later challenge.
   • SQL_CONNECTION_STRING: The easiest way to retrieve this is to open the web app deployed to the location 1 resource group (openhack1), open Configuration, then copy the SqlConnection connection string value.

When you need to execute the data generator, perform the following, based on your platform:

1. Windows:

   • Simply execute DataGenerator.exe inside the win-x64 folder.

2. Linux:

   • Navigate to the linux-x64 folder.
   • Run chmod 777 DataGenerator to provide access to the binary.
   • Run ./DataGenerator.

3. MacOS:

   • Open a new terminal.
   • Navigate to the osx-x64 directory.
   • Run ./DataGenerator.