Entity Framework
Gridify.EntityFramework Package
The Gridify.EntityFramework
package has two additional GridifyAsync()
and GridifyQueryableAsync()
methods.
Installation
Package Manager
shell
Install-Package Gridify.EntityFramework -Version 2.15.1
.NET CLI
shell
dotnet add package Gridify.EntityFramework --version 2.15.1
Compatibility layer
If you want to use gridify with Entity Framework, you should enable the compatibility layer:
csharp
GridifyGlobalConfiguration.EnableEntityFrameworkCompatibilityLayer();
Enabling the compatibility layer provides the following features:
- It tweaks the internal expression builder to make it compatible with Entity Framework.
- EF query optimization
- EF ServiceProviderCaching support
- Creates parameterized queries
sql
DECLARE @__Value_0 nvarchar(4000) = N'vahid';
SELECT [u].[Id], [u].[CreateDate], [u].[FkGuid], [u].[Name]
FROM [Users] AS [u]
WHERE [u].[Name] = @__Value_0
Configuration
EntityFrameworkCompatibilityLayer
Setting this property to true
Enables the EntityFramework Compatibility layer to make the generated expressions compatible with entity framework.
- type:
bool
- default:
false
EnableEntityFrameworkCompatibilityLayer()
Simply sets the EntityFrameworkCompatibilityLayer property to true
.
DisableEntityFrameworkCompatibilityLayer()
Simply sets the EntityFrameworkCompatibilityLayer property to false
.