Skip to content

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.14.1

.NET CLI

shell
dotnet add package Gridify.EntityFramework --version 2.14.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 whit entity framework.

  • type: bool
  • default: false

EnableEntityFrameworkCompatibilityLayer()

Simply sets the EntityFrameworkCompatibilityLayer property to true.

DisableEntityFrameworkCompatibilityLayer()

Simply sets the EntityFrameworkCompatibilityLayer property to false.