An adapter for using the Fluent UI Blazor DataGrid with Entity Framework.
$ dotnet add package Microsoft.FluentUI.AspNetCore.Components.DataGrid.EntityFrameworkAdapterUse this package if the data you want to display in the FluentDataGrid (component in the Microsoft.FluentUI.AspNetCore.Components library) comes from EF Core:
EF Core's DataContext gives you a DbSet property for each table in your database. Simply supply this as the grid's RowsData parameter:
@inject ApplicationDbContext MyDbContext
<FluentDataGrid RowsData="@MyDbContext.People">
...
</FluentDataGrid>
You may also use any EF-supported LINQ operator to filter the data before passing it:
@inject ApplicationDbContext MyDbContext
<FluentDataGrid RowsData="@MyDbContext.Documents.Where(d => d.CategoryId == currentCategoryId)">
...
</FluentDataGrid>
The FluentDataGrid recognizes EF-supplied IQueryable instances and knows how to resolve queries asynchronously for efficiency.
Install the package by running the command:
dotnet add package Microsoft.FluentUI.AspNetCore.Components.DataGrid.EntityFrameworkAdapter
In your Program.cs file you need to add the following:
builder.Services.AddDataGridEntityFrameworkAdapter();