In this blog post, we are going through the step-by-step procedure to connect  Syncfusion Blazor DataGrid with an  MS SQL Server database using  Entity Framework Core and perform CRUD operations in a Blazor WebAssembly application.

To demonstrate CRUD operations in the Syncfusion Blazor DataGrid component, we are going to create a simple library book management application. The final code can be found in this  GitHub repository.

Prerequisite software

The following software is needed:

• Visual Studio 2019 v16.8.0 Preview 3.0 or later
• .NET SDK 5.0 RC2 or later
• SQL Server 2017

Create the database

First things first, create a Library database and a table named Book to hold a list of books:

1. Open SQL Server 2017.
2. Create a new database named Library.
3. Right-click on the created database and select New Query.
4. Use the following SQL query to create a table named Book .

#blazor #datagrid #crud #sql