DbaClientX

DbaClientX is a lightweight, multi‑provider database client for .NET and PowerShell. It offers:

• Providers: SQL Server, PostgreSQL, MySQL, SQLite, Oracle
• Sync/async APIs with cancellation, retries, and transactions
• Transaction wrapper helpers that commit on success and roll back on failures
• A small SQL query builder with dialect support and parameterization
• PowerShell cmdlets for quick scripting

Repo structure

• DbaClientX.Core – shared base (DatabaseClientBase), retry logic, query builder
• DbaClientX.SqlServer / PostgreSql / MySql / SQLite / Oracle – providers
• DbaClientX.PowerShell – PowerShell cmdlets
• DbaClientX.Tests – xUnit unit tests
• Module – Pester tests and module build script

Build & test

dotnet restore DbaClientX.sln
dotnet build DbaClientX.sln -c Release
dotnet test DbaClientX.sln -c Release --framework net8.0

Release packaging (manual signing)

Package publishing is intentionally manual in this repository because releases are signed locally with the USB key certificate.

1. Generate a build plan:

pwsh.exe -NoLogo -NoProfile -File .\Build\Build-Project.ps1 -Plan $true

2. Build signed packages locally:

pwsh.exe -NoLogo -NoProfile -File .\Build\Build-Project.ps1 -Build $true -PublishNuget $false -PublishGitHub $false

3. Publish NuGet and GitHub together in one versioned run:

pwsh.exe -NoLogo -NoProfile -File .\Build\Build-Project.ps1 -PublishNuget $true -PublishGitHub $true

Build configuration lives in Build/project.build.json and artifacts are generated under Artefacts/ProjectBuild.

Notes

• The solution enables nullable reference types and .NET analyzers via Directory.Build.props.
• SourceLink is enabled for all projects for better debugging into packages.
• SQL Server provider uses Microsoft.Data.SqlClient.
• The release wrapper now treats version updates as part of publishing. If you intentionally need a replay-only publish for already-versioned artifacts, pass -UpdateVersions $false explicitly.