EasyReasy.Database.Mapping.Npgsql
1.0.0
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package EasyReasy.Database.Mapping.Npgsql --version 1.0.0
NuGet\Install-Package EasyReasy.Database.Mapping.Npgsql -Version 1.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="EasyReasy.Database.Mapping.Npgsql" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="EasyReasy.Database.Mapping.Npgsql" Version="1.0.0" />
<PackageReference Include="EasyReasy.Database.Mapping.Npgsql" />
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 EasyReasy.Database.Mapping.Npgsql --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: EasyReasy.Database.Mapping.Npgsql, 1.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 EasyReasy.Database.Mapping.Npgsql@1.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=EasyReasy.Database.Mapping.Npgsql&version=1.0.0
#tool nuget:?package=EasyReasy.Database.Mapping.Npgsql&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
EasyReasy.Database.Mapping.Npgsql
Npgsql-specific enum handler for EasyReasy.Database.Mapping. Automatically sets NpgsqlParameter.DataTypeName on enum parameters, eliminating the need for ::pg_type casts in SQL queries.
Installation
dotnet add package EasyReasy.Database.Mapping.Npgsql
Usage
With the base DbNameEnumHandler<T>, you need explicit casts in your SQL:
// Without this package — requires ::mapping_test_status cast
TypeHandlerRegistry.AddTypeHandler(new DbNameEnumHandler<TestStatus>());
await connection.ExecuteAsync(
"INSERT INTO users (name, status) VALUES (@name, @status::user_status)",
new { name = "Alice", status = UserStatus.Active });
With NpgsqlDbNameEnumHandler<T>, the cast is handled automatically:
// With this package — no cast needed
TypeHandlerRegistry.AddTypeHandler(new NpgsqlDbNameEnumHandler<UserStatus>("user_status"));
await connection.ExecuteAsync(
"INSERT INTO users (name, status) VALUES (@name, @status)",
new { name = "Alice", status = UserStatus.Active });
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. 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.
-
net8.0
- EasyReasy.Database.Mapping (>= 1.0.1)
- Npgsql (>= 8.0.8)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.