Use Semantic Kernel to create a Restaurant Bookings Sample with .NET

Sophia Lagerkrans-Pandey

Roger Barreto

Hi all,

With Microsoft Build approaching, we wanted to share some walk throughs and samples of Semantic Kernel. Today we’re going to dive into a Restaurant booking sample to showcase multiple features of Semantic Kernel.

This sample provides a practical demonstration of how to leverage features from the Semantic Kernel to build a console application. Specifically, the application utilizes the Business Schedule and Booking API through Microsoft Graph to enable a Large Language Model (LLM) to book restaurant appointments efficiently. This guide will walk you through the necessary steps to integrate these technologies seamlessly.

Semantic Kernel Features Used

• Plugin – Creating a Plugin from a native C# Booking class to be used by the Kernel to interact with Bookings API.
• Chat Completion Service – Using the Chat Completion Service OpenAI Connector implementation to generate responses from the LLM.
• Chat History Using the Chat History abstraction to create, update and retrieve chat history from Chat Completion Models.
• Auto Function Calling Enables the LLM to have knowledge of current importedUsing the Function Calling feature automatically call the Booking Plugin from the LLM.

Prerequisites

• .NET 8.
• Microsoft 365 Business License to use Business Schedule and Booking API.

Function Calling Enabled Models

This sample uses function calling capable models and has been tested with the following models:

ℹ️ OpenAI Models older than 0613 version do not support function calling.

ℹ️ When using Azure OpenAI, ensure that the model name of your deployment matches any of the above supported models names.

Configuring the sample

The sample can be configured by using the command line with .NET Secret Manager to avoid the risk of leaking secrets into the repository, branches and pull requests.

Create an App Registration in Azure Active Directory

1. Go to the Azure Portal.
2. Select the Azure Active Directory service.
3. Select App registrations and click on New registration.
4. Fill in the required fields and click on Register.
5. Copy the Application (client) Id for later use.
6. Save Directory (tenant) Id for later use..
7. Click on Certificates & secrets and create a new client secret. (Any name and expiration date will work)
8. Copy the client secret value for later use.
9. Click on API permissions and add the following permissions:
   • Microsoft Graph
     • Application permissions
       • BookingsAppointment.ReadWrite.All
     • Delegated permissions
       • OpenId permissions
         • offline_access
         • profile
         • openid

Create Or Use a Booking Service and Business

1. Go to the Bookings Homepage website.
2. Create a new Booking Page and add a Service to the Booking (Skip if you don’t ).
3. Access Graph Explorer
4. Run the following query to get the Booking Business Id:

GET https://graph.microsoft.com/v1.0/solutions/bookingBusinesses

1. Copy the Booking Business Id for later use.
2. Run the following query and replace it with your Booking Business Id to get the Booking Service Id

GET https://graph.microsoft.com/v1.0/solutions/bookingBusinesses/{bookingBusiness-id}/services

1. Copy the Booking Service Id for later use.

Using .NET Secret Manager

dotnet user-secrets set "BookingServiceId" " .. your Booking Service Id .. "
dotnet user-secrets set "BookingBusinessId" " .. your Booking Business Id ..  "

dotnet user-secrets set "AzureEntraId:TenantId" " ... your tenant id ... "
dotnet user-secrets set "AzureEntraId:ClientId" " ... your client id ... "

# App Registration Authentication
dotnet user-secrets set "AzureEntraId:ClientSecret" " ... your client secret ... "

# OR User Authentication (Interactive)
dotnet user-secrets set "AzureEntraId:InteractiveBrowserAuthentication" "true"
dotnet user-secrets set "AzureEntraId:RedirectUri" " ... your redirect uri ... "

# OpenAI (Not required if using Azure OpenAI)
dotnet user-secrets set "OpenAI:ModelId" "gpt-3.5-turbo"
dotnet user-secrets set "OpenAI:ApiKey" "... your api key ... "
dotnet user-secrets set "OpenAI:OrgId" "... your ord ID ... " # (Optional)

# Using Azure OpenAI (Not required if using OpenAI)
dotnet user-secrets set "AzureOpenAI:DeploymentName" " ... your deployment name ... "
dotnet user-secrets set "AzureOpenAI:ApiKey" " ... your api key ... "
dotnet user-secrets set "AzureOpenAI:Endpoint" " ... your endpoint ... "

Running the Sample

After configuring the sample, to build and run the console application just hit F5.

To build and run the console application from the terminal use the following commands:

dotnet build
dotnet run

Example of a Conversation

User > Please book a restaurant for me.

Assistant > Sure, I can help you with that. Could you please provide me with the following information:

1. Name of the restaurant you would like to book.
2. Date and time of the reservation.
3. Number of people in your party.
4. Your name.
5. Your email address.
6. Your phone number.

Once I have all this information, I will proceed with the booking.

User > I would like to book a table at the restaurant “The French Laundry” on the 15th of March at 7:00 PM for 4 people. My name is John Doe, my email address is john@internet.com, and my phone number is 123-456-7890.

System > Do you want to book a table at The French Laundry on 15/03/2023 19:00:00 for 4 people?

System > Please confirm by typing ‘yes’ or ‘no’.

User > yes

Assistant > Great! I have successfully booked a table for you at “The French Laundry” on the 15th of March at 7:00 PM for 4 people. Your reservation has been made under the name John Doe. If you have any further questions or need to make any changes to your reservation, please let me know.

User > List my current bookings

Assistant > You currently have one booking:

• Restaurant: The French Laundry
• Date and Time: 15th of March at 7:00 PM
• Party Size: 4 people

If you need any further assistance or if there’s anything else I can help you with, please let me know.

User > Cancel my booking

System > [Cancelling a reservation for 4 at The French Laundry on 2023-03-15 at 19:00:00]

Assistant > I have successfully canceled your booking at “The French Laundry” on the 15th of March at 7:00 PM for 4 people.

Dive Deeper

Please reach out if you have any questions or feedback through our Semantic Kernel GitHub Discussion Channel. We look forward to hearing from you!

Sophia Lagerkrans-Pandey

Follow

Roger Barreto

Follow