EFCore.ReturningExtensions.MySql
11.0.0
dotnet add package EFCore.ReturningExtensions.MySql --version 11.0.0
NuGet\Install-Package EFCore.ReturningExtensions.MySql -Version 11.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="EFCore.ReturningExtensions.MySql" Version="11.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="EFCore.ReturningExtensions.MySql" Version="11.0.0" />
<PackageReference Include="EFCore.ReturningExtensions.MySql" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add EFCore.ReturningExtensions.MySql --version 11.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: EFCore.ReturningExtensions.MySql, 11.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package EFCore.ReturningExtensions.MySql@11.0.0
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=EFCore.ReturningExtensions.MySql&version=11.0.0
#tool nuget:?package=EFCore.ReturningExtensions.MySql&version=11.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
EF Core Returning Extensions
Features
- 🚀 Single Round Trip - Retrieve affected rows without additional SELECT queries
Installation
.NET CLI
dotnet add package EFCore.ReturningExtensions.MySql
Usage
Configure
public class ItemsDbContext(DbContextOptions<ItemsDbContext> options) : DbContext(options)
{
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseMySql(connectionString, MariaDbServerVersion.LatestSupportedServerVersion, o =>
{
o.UseReturningExtensions();
});
}
}
Update
To get updated
var updatedItems = dbContext.Items
.AsNoTracking()
.Where(x => x.Name.Length < 100)
.Updated(s => s.SetProperty(p => p.Name, p => p.Name + "_suffix"), x => x)
.ToList();
or to get previous values
var previousItems = dbContext.Items
.AsNoTracking()
.Where(x => x.Name.Length < 100)
.Updated(s => s.SetProperty(p => p.Name, p => p.Name + "_suffix"), (x, y) => y)
.ToList();
or to get mixed values
var itemChanges = dbContext.Items
.AsNoTracking()
.Where(x => x.Name.Length < 100)
.Updated(s => s.SetProperty(p => p.Name, p => p.Name + "_suffix"), (x, y) => new { Change = y.Name + "|>" + x.Name })
.ToList();
Delete
var deletedItems = dbContext.Items
.AsNoTracking()
.Where(x => x.Name.Length < 100)
.Deleted(x => x)
.ToList();
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net11.0 is compatible. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net11.0
- EFCore.ReturningExtensions (>= 11.0.0)
- Microting.EntityFrameworkCore.MySql (>= 11.0.0-preview.1 && < 12.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.