Home

Awesome

page_type: sample languages:

<!--- category: ControlsLayoutAndText Data IdentitySecurityAndEncryption Navigation NetworkingAndWebServices -->

Customers Orders Database sample

A WinUI 3 sample app that showcases UI controls (including a data grid) and the latest design guidance for apps on Windows 11. It also demonstrates features useful to enterprise developers, like Azure Active Directory (AAD) authentication, Sqlite and SQL Azure database integration, Entity Framework, and cloud API services. The sample is based around creating and managing customer accounts, orders, and products for the fictitious company Contoso.

Note - This sample is targeted and tested for Windows 11 Insider Preview using the Insider Preview SDK Build 22000, and Visual Studio 2022 version 17.1 or later. If you are developing on Windows 10, retarget the Contoso.App project to Windows 10, version 2004 (10.0; Build 19041).

ContosoApp screenshot 1

May 2022 update

This update includes:

Previous updates

August 2021 update

This update includes:

To see how we updated the UI to look at home on Windows 11, see Updating the Customers Orders Database sample UI to Windows 11.

June 2020 update

This update includes:

Older

Features

This sample highlights:

This sample is designed to cover the core scenarios with minimal architectural complexity. For a more complex, full-featured sample that covers many of the same scenarios using a more sophisticated architecture, see the VanArsdel Inventory sample.

Run the sample

This sample is designed to connect to an instance of Azure Active Directory for authentication and an external service for data. To get you started right away, we've provided some demo data and a test service you can connect to. However, in order to debug and explore the full functionality of the app, you'll need to deploy your own instance to Azure.

Quick start

Prepare your environment

To get the latest updates to Windows and the development tools, and to help shape their development, join the Windows Insider Program.

Run

Set your startup project as Contoso.App, the architecture to x86 or x64, and press F5 to run.

Complete setup

To fully explore the sample, you'll need to connect to your own Azure Active Directory and data source. Values you need to fill are in Constants.cs.

Run

You can then either start the service running locally, or deploy it to Azure.

Register the Azure Active Directory app (Web api)

First, complete the steps in Register an application with the Microsoft identity platform to register the web application.

App registration <br/> settingValue for this sample appNotes
Nameactive-directory-contoso-customer-oders-protected-apiSuggested value for this sample. <br/> You can change the app name at any time.
Supported account typesAccounts in this organizational directory only (Any Azure AD directory - Multitenant)Required for this sample. <br/> Support for the Single tenant.
Expose an APIScope name: Contoso.ReadWrite<br/>Who can consent?: Admins and users<br/>Admin consent display name: Act on behalf of the user<br/>Admin consent description: Allows the API to act on behalf of the user.<br/>User consent display name: Act on your behalf<br/>User consent description: Allows the API to act on your behalf.<br/>State: EnabledAdd a new scope that reads as follows api://{clientId}/Contoso.ReadWrite. Required value for this sample.

Register the Azure Active Directory app (Client desktop app)

Then, complete the steps in Register an application with the Microsoft identity platform to register the deskptop application.

App registration <br/> settingValue for this sample appNotes
Nameactive-directory-contoso-customer-oders-winui3Suggested value for this sample. <br/> You can change the app name at any time.
Supported account typesAccounts in any organizational directory (Any Azure AD directory - Multitenant)Suggested value for this sample.
Platform typeMobile and desktop applicationsRequired value for this sample
Redirect URIshttps://login.microsoftonline.com/common/oauth2/nativeclientRequired value for this sample
API Permissionsactive-directory-contoso-customer-oders-protected-api <br/> Contoso.ReadWriteAdd a new delegated permission for api://<application-id>/Contoso.ReadWrite. Required value for this sample.

Run locally (SQLite)

  1. Navigate to Constants.cs and complete the following value using the active-directory-contoso-customer-oders-winui3 Application (client) ID from Azure Portal:

    ...
public const string AccountClientId = "Application_Client_ID_From_Azure_Portal";
...

  2. Right-click the Contoso.App project, choose Set as Startup Project.

  3. Press F5

  4. Navigate to Settings and ensure it is selected the SQLite option.

Run locally (REST)

  1. Install SQL LocalDB. You could easily install SQL LocalDB using the Visual Studio Installer from Individual Components by searching for the term Local DB or you can find other ways to install this from SQL Server Express LocalDB Installation Media.

    Note: The intructions in here are using SQL Express LocalDB, but you can use any SQL Server instance at your disposal.

  2. Open a Windows Terminal and create a new LocalDB instance

    SqlLocalDB.exe create "ContosoDb"

  3. Start the new LocalDB

    SqlLocalDB.exe start "ContosoDb"

  4. Copy your LocalDB instance pipe number from the output of executing the following command

    SqlLocalDB.exe info "ContosoDb"

  5. Create the new Database. Please note that below we used mssql-cli, but you could opt to use any tool for querying SQL Server of your preference.

    mssql-cli -S np:\\.\pipe\LOCALDB#<instance-pipe-number>\tsql\query -E -i .\ContosoApp\Assets\ContosoDb.sql

  6. Right-click the solution, choose Properties, and choose to start both Contoso.App and Contoso.Service at the same time.

  7. Open the appsettings.json file and modify the following field using the active-directory-contoso-customer-oders-protected-api Application (client) ID from Azure Portal:

    ...
"ClientId": "Enter_the_Application_Id_here"
...

  8. Navigate to Constants.cs and complete the following values:

    public const string ApiUrl = @"http://localhost:65027";
...
public const string AccountClientId = "Application_Client_ID_From_Azure_Portal";
public const string WebApiClientId = "Application_Client_ID_From_Azure_Portal";
...
public const string SqlAzureConnectionString = "Data Source=(LocalDB)\\ContosoDb;Initial Catalog=CONTOSODB;Integrated Security=True";
...

  9. Press F5

  10. Navigate to Settings and select the REST option, so the Database Customer Orders sample app starts using the service endpoints.

Deploy to Azure

  1. right-click Contoso.Service, choose Publish, and then follow the steps in the wizard.

Code at a glance

If you're only interested in specific tasks and don't want to browse or run the entire sample, check out some of these files:

Design patterns

List/details

The Orders list screen displays a list of orders. It uses visual state triggers to selectively display an additional details panel when the screen is large enough. To see the full details of an order or to edit it, the user selects "Edit" to go to the Order details screen. The Order details screen shows all the info for the order and enables editing. The user can search for additional products to add to the invoice.

Form layouts

The two details screens show how to use headings, labels, and whitespace to organize controls into a form layout. Some controls used include:

See also