This repository contains simple demo .NET 8 projects to show how to use Data API Builder (DAB) to create REST & GrapQL APIs to access data from a SQL Server database, and how to use Strawberry Shake to generate a GraphQL client for different .NET applications.
Those demos were used in videos and blog posts.
-
Azure Developers .NET Days:
-
Why and How to Execute GraphQL Queries in .NET
- To reproduce the demo of this post, you will need to create a file
.envin the folder database-api (see the file.env.samplefor an example) to set the password of the the database user sa. Then execute the commanddocker-compose upfrom that same folder to start the SQL Server database and APIs containers. This should take a moment to download the container images and start everything. Then you can run follow the instructions of the post to build the .NET Console Application.
- To reproduce the demo of this post, you will need to create a file
The folder database-api contains a simple docker-compose up that deploys an SQL Server in a first container and Data API Builder (DAB) in a second one. When the database container starts, it runs automatically a SQL script startrek.sql to create the database tables and populate the Star Trek tables. Finally the DAB container starts and connects to the SQL Server database to expose a REST API and a GraphQL API.
To run it locally, create a file .env in the folder database-api (see the file .env.sample for an example) to set the password of the the database user sa. Then execute the command docker-compose up from that same folder to start the SQL Server database and APIs containers. This should take a moment to download the container images and start everything. The GraphQL API will be available at http://localhost:5000/graphql.
The folder src/console/ contains a console application the uses the GraphQL client generated with the StrawberryShake package to query the GraphQL API exposed by DAB. The application is a simple console application that queries the GraphQL API to get the list of Star Trek characters by series. To run it locally you need to have the database and APIs containers running.
The folder src/startrek-wasm/ contains a Blazor WebAssembly website to demonstrate how to use GraphQL with QuickGrid. The website uses the generated component and client, using the StrawberryShake.Blazor package to query the GraphQL API to display the list of Actors. A second page shows how to use QuickGrid with the virtualize feature to display a large list of actors. To run it locally you need to have the chocoSpock GraphQL API running.
The folder src/web/ contains a Blazor website to demonstrate how to use GraphQL with QuickGrid. The website uses the generated component and client, using the StrawberryShake.Blazor package to query the GraphQL API to display the list of Actors. A second page shows how to use QuickGrid with the virtualize feature to display a large list of actors. To run it locally you need to have the chocoSpock GraphQL API running.
The folder src/chocoSpock/ contains a simple GraphQL endpoint that implements the required skip and take arguments to allow virtualization with Blazor QuickGrid. The minimal API uses HotChocolate nuget package.
To run it locally, you need to have the startrek database up and running. Create a file .env in the folder database-api (see the file .env.sample for an example) to set the password of the the database user sa. Then execute the command docker-compose up from that same folder to start the SQL Server database and APIs containers. This should take a moment to download the container images and start everything.
Now that the database is running, you can start the chocoSpock API by running the command dotnet run in a second terminal from the folder src/chocoSpock/. The GraphQL API will be available at http://localhost:5041/graphql.