Anarchy.Toolkit.Infrastructure.Persistence.Mysql 1.1.5

There is a newer version of this package available.
See the version list below for details.
dotnet add package Anarchy.Toolkit.Infrastructure.Persistence.Mysql --version 1.1.5
                    
NuGet\Install-Package Anarchy.Toolkit.Infrastructure.Persistence.Mysql -Version 1.1.5
                    
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="Anarchy.Toolkit.Infrastructure.Persistence.Mysql" Version="1.1.5" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Anarchy.Toolkit.Infrastructure.Persistence.Mysql" Version="1.1.5" />
                    
Directory.Packages.props
<PackageReference Include="Anarchy.Toolkit.Infrastructure.Persistence.Mysql" />
                    
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 Anarchy.Toolkit.Infrastructure.Persistence.Mysql --version 1.1.5
                    
#r "nuget: Anarchy.Toolkit.Infrastructure.Persistence.Mysql, 1.1.5"
                    
#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 Anarchy.Toolkit.Infrastructure.Persistence.Mysql@1.1.5
                    
#: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=Anarchy.Toolkit.Infrastructure.Persistence.Mysql&version=1.1.5
                    
Install as a Cake Addin
#tool nuget:?package=Anarchy.Toolkit.Infrastructure.Persistence.Mysql&version=1.1.5
                    
Install as a Cake Tool

Anarchy.Toolkit.Infrastructure.Persistence.Mysql

MySQL adapter for the toolkit's relational persistence layer, using MySqlConnector.

dotnet add package Anarchy.Toolkit.Infrastructure.Persistence.Mysql
  • MysqlDbDialect, connection pools, unit of work, retry policy and repository bases adapt the shared relational layer to MySQL.
  • Register an Observer in DI and configure ModuleMysql with connection and resilience options factories; AddMysqlHealthReports() adds reader and writer checks.
  • The unkeyed storage policy uses the writer; use the reader key for read-only operations. Port 3306 is the default.
  • Named session time zones require populated MySQL time-zone tables. Retry the whole unit of work rather than individual commands inside a transaction.

When to use it

Use this adapter for a MySQL-backed application that needs the toolkit's relational policies, unit of work and repository bases. The consuming application supplies its schema, migrations and MySQL-specific queries.

How to use it

  1. Register an Observer and use ModuleMysql with factories for MysqlConnectionOptions and MysqlResilienceOptions. Obtain hosts and credentials from the environment or a secret provider rather than committing them.
  2. Configure reader/writer hosts, database name, command timeout and optional session time zone. The port defaults to 3306 and MaximumPoolSize defaults to 100; tune pool size for the database and number of application instances.
  3. Implement repositories with the MySQL bases and select the keyed reader policy for read-only work. The unkeyed policy uses the writer. Add AddMysqlHealthReports() if the host should check both endpoints.
  4. Validate the integration against a dedicated MySQL test database using Testing.Mysql. If a transaction fails, retry the whole unit of work rather than individual statements inside it.

See the MySQL usage notes and Testing.Mysql.

Releases

1.1.5

  • docs: expand XML docblocks across all projects for the DocFX API reference

1.1.4

  • refactor(src): clean up code style across library packages
  • chore(deps): update AWS SDK, Lambda ASP.NET Core server and MySqlConnector packages

1.1.2

  • build: migrate local automation to build tooling

1.1.1

  • docs: expand package guides and release histories
  • chore(deps): update AWS, Polly, and xUnit packages

1.1.0

  • Applied the configurable maximum pool size to MySQL connection strings.

1.0.1

  • Added a package-specific NuGet README.

1.0.0

  • Introduced the MySQL relational persistence provider, connection handling and provider-specific health reports.
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.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on Anarchy.Toolkit.Infrastructure.Persistence.Mysql:

Package Downloads
Anarchy.Toolkit.Testing.Mysql

MySQL integration-test fixtures, settings mapping, enum handlers and table reset helpers.

GitHub repositories

This package is not used by any popular GitHub repositories.

Initial release.