What's Changed

💥 Breaking Changes

• Added the optional reuse parameter to SimpleParameterInfo and DefineParam<T>. This changes their binary signatures, so dependent applications and libraries compiled against an earlier release must be recompiled. by @mishael-o in #117
• Replaced the dedicated .NET 9 target with .NET 10 while retaining the .NET 8 and .NET Standard targets. by @mishael-o in #117

✨ New Features

• Added per-parameter reuse control through DefineParam(..., reuse: false), independently of the builder-level reuseParameters setting. Defined parameters continue to be reused by default. by @mishael-o in #117

🐛 Bug Fixes

• Fixed duplicate OffsetRows and FetchNext calls appending invalid ROWS or ONLY SQL fragments. by @mishael-o in #117
• Corrected conditional OrWhere interpolated-string handling. by @mishael-o in #117
• Fixed package and GitHub release publishing detection by evaluating repository-relative paths from the repository root. by @mishael-o in #118

🛠 Enhancements

• Reduced intermediate formatting allocations by writing formatted values directly to the destination SQL buffer. by @mishael-o in #117
• Replaced mutable parameter-name tracking with immutable, builder-local parameter keys based on parameter value, runtime type, database type, size, precision, and scale. by @mishael-o in #117
• Migrated the solution to .slnx, xUnit v3, Microsoft Testing Platform, NSubstitute, and .NET 10 tooling. by @mishael-o in #117
• Refreshed the documentation website, parameter reuse guidance, API references, CI/CD workflows, and performance results. by @mishael-o in #117

📦 Other Changes

• Improved documentation, updated dependencies, clarified configuration guidance, and cleaned up formatting. by @mishael-o in #113
• Refactored unit tests to use Shouldly and removed FluentAssertions. by @mishael-o in #114
• Restored the README acknowledgements section to link to the documentation page and removed the JetBrains acknowledgement. by @mishael-o in #119

Full Changelog: v4.2.3...v5.0.3

What's Changed

💥 Breaking Changes

• Added the optional reuse parameter to SimpleParameterInfo and DefineParam<T>. This changes their binary signatures, so dependent applications and libraries compiled against an earlier release must be recompiled. by @mishael-o in #117
• Replaced the dedicated .NET 9 target with .NET 10 while retaining the .NET 8 and .NET Standard targets. by @mishael-o in #117

✨ New Features

• Added per-parameter reuse control through DefineParam(..., reuse: false), independently of the builder-level reuseParameters setting. Defined parameters continue to be reused by default. by @mishael-o in #117

🐛 Bug Fixes

• Fixed duplicate OffsetRows and FetchNext calls appending invalid ROWS or ONLY SQL fragments. by @mishael-o in #117
• Corrected conditional OrWhere interpolated-string handling. by @mishael-o in #117
• Fixed package and GitHub release publishing detection by evaluating repository-relative paths from the repository root. by @mishael-o in #118

🛠 Enhancements

• Reduced intermediate formatting allocations by writing formatted values directly to the destination SQL buffer. by @mishael-o in #117
• Replaced mutable parameter-name tracking with immutable, builder-local parameter keys based on parameter value, runtime type, database type, size, precision, and scale. by @mishael-o in #117
• Migrated the solution to .slnx, xUnit v3, Microsoft Testing Platform, NSubstitute, and .NET 10 tooling. by @mishael-o in #117
• Refreshed the documentation website, parameter reuse guidance, API references, CI/CD workflows, and performance results. by @mishael-o in #117

📦 Other Changes

• Improved documentation, updated dependencies, clarified configuration guidance, and cleaned up formatting. by @mishael-o in #113
• Refactored unit tests to use Shouldly and removed FluentAssertions. by @mishael-o in #114

Full Changelog: v4.2.3...v5.0.1-beta

What's Changed

✨ New Features

• Introduced CollectionParameterTemplateFormat for enhanced parameter handling to avoid collisions when parameter collections are expanded. by @mishael-o in #107

🐛 Bug Fixes

• Fix CollectionParameterFormat construction logic when set, to use the right values. by @mishael-o in #110

🛠 Enhancements

• Dropped net462 target. However, the library still targets netstandard2.0 which supports net462 to net481. by @mishael-o in #108

📦 Other Changes

• Fix for doc-site xref reference. by @mishael-o in #103

Full Changelog: v4.1.2...v4.2.3

What's Changed

🐛 Bug Fixes

• Fix CollectionParameterFormat construction logic when set to use the right values. by @mishael-o in #110

Full Changelog: v4.2.0-beta...v4.2.1-beta

What's Changed

✨ New Features

• Introduced CollectionParameterTemplateFormat for enhanced parameter handling to avoid collisions when parameter collections are expanded by @mishael-o in #107

🛠 Enhancements

• Dropped net462 target. However, the library still targets netstandard2.0 which supports net462 to net481. by @mishael-o in #108

📦 Other Changes

• Fix for doc-site xref reference. by @mishael-o in #103

Full Changelog: v4.1.2...v4.2.0-beta

What's Changed

✨ New Features

• Added Create method on SimpleBuilder and ISimpleBuilder that uses interpolated string handler for improved performance. by @mishael-o in #98
• Added support for .NET 9 and .NET 4.6.2. by @mishael-o in #99

📦 Other Changes

• Dropped .NET 6 and .NET 4.6.1 support. by @mishael-o in #99
• Bumped docfx version to 2.78.2. by @mishael-o in #99
• Improvements to documentation generation and test NuGet package updates by @mishael-o in #95

Full Changelog: v4.0.5...v4.1.2

What's Changed

📦 Other Changes

• Updated descriptions and tags. by @mishael-o in #100

Full Changelog: v4.1.0-beta...v4.1.1-beta

What's Changed

✨ New Features

• Added a new Create method on SimpleBuilder and ISimpleBuilder which uses an interpolated string handler for improved performance. by @mishael-o in #98
• Added support for .NET 9 and .NET 4.6.2. by @mishael-o in #99

📦 Other Changes

• Dropped .NET 6 and .NET 4.6.1 support. by @mishael-o in #99
• Bumped docfx version to 2.78.2. by @mishael-o in #99
• Improvements to documentation generation and test NuGet package updates by @mishael-o in #95

Full Changelog: v4.0.5...v4.1.0-beta

What's Changed

💥 Breaking Changes

• Dropped the interfaces IWhereBuilderEntry and IWhereFilterBuilderEntry and moved the methods to the IWhereBuilder by @mishael-o in #89
• The Fluent Builder now throws an InvalidOperationException when two entry clauses are called on the same instance. i.e. calling Select and InsertInto on the same builder instance by @mishael-o in #89

🛠 Enhancements

• Improvements to the Fluent Builder to allow the use of all Where clause methods when writing dynamic SQL by @mishael-o in #89

📦 Other Changes

• Updated NuGet packages by @mishael-o in #88
• Enhanced documentation clarity, updated code examples, and corrected grammatical errors by @mishael-o in #90
• Added FUNDING.yml to project by @mishael-o in #91
• Refined docs and updated MySQL test version by @mishael-o in #92

New Contributors

• @github-actions made their first contribution in #86

Full Changelog: v3.7.4...v4.0.5

What's Changed

📦 Other Changes

• Enhanced documentation clarity, updated code examples, and corrected grammatical errors by @mishael-o in #90
• Added to FUNDING.yml to project by @mishael-o in #91
• Refined docs and updated MySQL test version by @mishael-o in #92

Full Changelog: v4.0.0-beta...v4.0.3-beta