Alvecta.Foundation.Infrastructure.EF.AuroraDsql 9.0.83

.NET 10.0

dotnet add package Alvecta.Foundation.Infrastructure.EF.AuroraDsql --version 9.0.83

NuGet\Install-Package Alvecta.Foundation.Infrastructure.EF.AuroraDsql -Version 9.0.83

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="Alvecta.Foundation.Infrastructure.EF.AuroraDsql" Version="9.0.83" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="Alvecta.Foundation.Infrastructure.EF.AuroraDsql" Version="9.0.83" />
                    

                            Directory.Packages.props

<PackageReference Include="Alvecta.Foundation.Infrastructure.EF.AuroraDsql" />
                    

                            Project file

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 Alvecta.Foundation.Infrastructure.EF.AuroraDsql --version 9.0.83

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Alvecta.Foundation.Infrastructure.EF.AuroraDsql, 9.0.83"

#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 Alvecta.Foundation.Infrastructure.EF.AuroraDsql@9.0.83

#: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=Alvecta.Foundation.Infrastructure.EF.AuroraDsql&version=9.0.83
                    

                            Install as a Cake Addin

#tool nuget:?package=Alvecta.Foundation.Infrastructure.EF.AuroraDsql&version=9.0.83
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Alvecta.Foundation.Infrastructure.EF.AuroraDsql

Amazon Aurora DSQL wiring for Alvecta.Foundation.Infrastructure.EF: the DbDataSource that connects with IAM authentication, and the DbContext options that make EF Core migrations and transactions work on DSQL.

It belongs to the Infrastructure layer. Dependencies: Alvecta.Foundation.Infrastructure.EF, Alvecta.Utils.EF.AuroraDsql, Amazon.AuroraDsql.Npgsql, AWSSDK.DSQL, Npgsql and Npgsql.EntityFrameworkCore.PostgreSQL.

What it contains

AuroraDsqlDbDataSourceProvider — the IDbDataSourceProvider. Builds one DsqlDataSource per connection string (cached for the life of the process) from its Host, Port, Database, Username and Search Path. Connections authenticate with IAM tokens from the default AWS credential chain, so the connection string carries no password. Schema names in the search path are quoted, so their casing is kept.
AuroraDsqlDbContextOptionsAction — the IDbContextOptionsAction. Calls UseNpgsql over that data source (PostgreSQL 16 compatibility, the migrations assembly from IMigrationsAssemblyProvider), then UseAuroraDsql from Alvecta.Utils.EF.AuroraDsql: a DSQL-compatible migrations SQL generator and history table, REPEATABLE READ transactions, and migrations that wait for asynchronous index builds to finish, logging their progress through the host's ILoggerFactory.
AlvectaFoundationEFAuroraDsqlStartup.ConfigureServices(IServiceCollection) — registers both and applies AuroraDsqlNpgsqlPatcher.Patch(), so transactions opened directly on an NpgsqlConnection work on DSQL too.

Usage

dotnet add package Alvecta.Foundation.Infrastructure.EF.AuroraDsql

Register it in the composition root, together with an IMigrationsAssemblyProvider for the project that holds your migrations:

using Alvecta.Foundation.Infrastructure.EF.AuroraDsql;
using Alvecta.Foundation.Infrastructure.EF.Persistence.DatabaseMigration;

AlvectaFoundationEFAuroraDsqlStartup.ConfigureServices(services);

services.AddSingleton<IMigrationsAssemblyProvider, MigrationsAssemblyProvider<OrdersMigrationsMarker>>();
services.AddLogging();

The SetDbContextOptions callback shown in the Alvecta.Foundation.Infrastructure.EF readme then resolves both services. A connection string looks like:

Server=<cluster-id>.dsql.<region>.on.aws;Database=postgres;User Id=admin;SearchPath=Orders

The process needs dsql:DbConnectAdmin (for the admin user) on the cluster. Alvecta.Foundation.Deployment.Cdk grants it to every service when the environment owns a cluster. Add Alvecta.Foundation.Infrastructure.EF.Postgres as well to create the schema before the first migration.

Product	Compatible and additional computed target framework versions.
.NET	net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net10.0
- Alvecta.Foundation.Infrastructure.EF (>= 9.0.83)
- Alvecta.Utils (>= 8.4.79)
- Alvecta.Utils.EF.AuroraDsql (>= 8.4.79)
- Amazon.AuroraDsql.Npgsql (>= 1.1.0)
- AWSSDK.Core (>= 4.0.102.14)
- AWSSDK.DSQL (>= 4.0.103.10)
- Microsoft.EntityFrameworkCore.Relational (>= 10.0.14)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 10.0.14)
- Microsoft.Extensions.Logging.Abstractions (>= 10.0.14)
- Npgsql (>= 10.0.3)
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 10.0.3)

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.