Links
Nuget package
|
dotnet add package Z.EntityFramework.Plus.EFCore
|
|
var items = await context.Items.FromCacheAsync();
// The first call perform a database round trip
// The following calls will take the value from the memory instead
// for immediate methods (count, first, single, contains, any), use a query Deferred
var count = await context.Items.DeferredCount().FromCacheAsync();
|
Allow to reduce database roundtrip by batching multiple queries in the same sql command.
|
|
var futureItems = dbContext.Items.Future();
var futureCategories = dbContext.Categories.Future();
// TRIGGER all pending queries (futureItems & futureCategories)
var items = await futureItems.ToListAsync();
// for immediate methods (count, first, single, contains, any), use a query Deferred
var futureItemCount = await context.Items.DeferredCount().FutureValue();
var count = futureItemCount.Value;
|
Allow to filter the included related entities. Useful only for many to many relationships.
It improves the performance because fewer elements are joined.
|
|
// get items belonging to the category C2.
context.Items.IncludeFilter(x => x.Categories.Where(x => x.Name == "C2"));
|
|
SELECT `t`.`id`, `t`.`name`
FROM `item` AS `i`
INNER JOIN (
SELECT `c`.`id`, `c`.`name`, `i0`.`itemId`
FROM `itemCategory` AS `i0`
INNER JOIN `category` AS `c` ON `i0`.`categoryId` = `c`.`id`
WHERE `c`.`name` = 'C2'
) AS `t` ON `i`.`id` = `t`.`itemId`
|
Allow to easily track changes, exclude/include entity or property and auto save audit entries in the database.
|
|
context.Items.Where(x => ids.Contains(x.Id))
.UpdateAsync(x => new Item { Name = "new name" },
x =>
{
x.Executing = command => Console.WriteLine(command.CommandText);
});
|
|
UPDATE A
SET A.[Name] = @zzz_BatchUpdate_0
FROM [Items] AS A
INNER JOIN (
SELECT [i].[Id], [i].[Name]
FROM [Items] AS [i]
WHERE [i].[Id] IN (1, 2)
) AS B
ON A.[Id] = B.[Id]
|
- Updates multiples rows
- in a single database roundtrip
- without loading entities in the context
Limitations:
- Do not support Complex Type
- Do not support TPC
- Do not support TPH
- Do not support TPT
If you need to use one of this feature, you need to use the paying library Entity Framework Extensions
Batch delete
- Deletes multiples rows
- in a single database roundtrip
- without loading entities in the context
