v6.5.0

• Implemented #488: Support OpenTelemetry TraceId and SpanId as provided by Serilog core
• Include README in NuGet package

v6.4.0

• Implemented #436: Truncate additional columns (thanks to @nhart12)
• Fixed issue #489: allow varchar on standard columns (thanks to @nhart12)

v6.3.0

• Implemented #360: Automatic DB creation

v6.2.0

• Implemented #454: LoggingLevelSwitch support to allows log level manipulation at runtime.
• Fixed issue #458: Error if enrich nullable int columns by null value
• Added CodeQL code scanning
• Generate code coverage file when running tests in Build.ps1

v6.1.0

Commits

• 050f99a: Bumped version to 6.0.1 (Christian Kadluba) #447
• 33f0485: Set InternalsVisibleTo in csproj file (Christian Kadluba) #447
• fdfea7d: Reorganization in tests project (Christian Kadluba) #447
• bf60005: Use NuGet central package management (Christian Kadluba) #447
• a55daf1: Code analysis fixes (Christian Kadluba) #447
• a131a45: Hierarchical property name support in SqlColumn class (Christian Kadluba) #447
• eb4f43b: Resolve hierarchical property expressions for additional columns (Christian Kadluba) #447
• aa2c116: Added documentation of hierachical property expressions in README (Christian Kadluba) #447
• bea1891: Added an integration test. (Christian Kadluba) #447
• 659374a: Added a sample of hierachical property expressions in WorkerServiceDemo (Christian Kadluba) #447
• cd2d62b: Bumped version to 6.1 (Christian Kadluba) #447
• 191b5b3: Fixed typo after review. Thanks @jonorossi! ;) (Christian Kadluba) #447
• cf6588e: Added PR code scanning (Christian Kadluba) #447
• 5a30ddc: Code QL PR analysis (Christian Kadluba) #447
• dc53566: SelfLog full exception info (Christian Kadluba) #447
• de063b8: Enabled EnforceCodeStyleInBuild. (Christian Kadluba) #447
• 79e4041: Rethrow general exception in SqlBulkBatchWriter. (Christian Kadluba) #447
• 82bd5da: Made a filed read only. (Christian Kadluba) #447
• 11ed7fb: Fixed GiHub action warning (Christian Kadluba) #447
• 1a173c1: Updated CHANGES.md (Christian Kadluba) #447

What's Changed

• Fixed issues #207, #435, #419 & #292: Resolve hierarchical property expressions for additional columns
• Fixed issue #432: Write full exception info to SelfLog
• Use NuGet central package management
• Added PR code security scanning (CodeQL & DevSkim)
• Reorganizations & small fixes

v6.0.0

Commits

• 890e1c6: Bumped version to 5.9.0 (Christian Kadluba) #430
• 507d323: Removed obsolete line in AppConfigDemp packages.config (Christian Kadluba) #430
• cfa976b: Removed obsolete and vulnerable Microsoft.Azure.Services.AppAuthentication (Christian Kadluba) #430
• 0fa7784: Consolidated Serilog nuget version in AppConfigDemo with other projects. (Christian Kadluba) #430
• a1b4c19: Fixed typo in README (Christian Kadluba) #430
• a949cea: Bumped Serilog.Sinks.PeriodicBatching to 3.1.0 to ensure compatibility with other sinks (Vladimir Mihok) #430
• a161ad1: fixed missing reference in AppConfigDemo app (Vladimir Mihok) #430
• b680ba7: Removed .NET Core 3.1 and updated to .NET 6.0 (Christian Kadluba) #430
• 4fc1070: Fixed failure to run .NET 6 tests (Christian Kadluba) #430
• cc8c114: Updated dependencies and removed obsolete code (Christian Kadluba) #430
• 080a1d8: Updated SqlClient to 5.0.1 (Christian Kadluba) #430
• 8ff612b: Bumped version to 6.0.0 (Christian Kadluba) #430
• a46ba97: Bring back icon file. (Christian Kadluba) #430
• e91d2c4: Updated issue template. Fixed indentation in csproj. (Christian Kadluba) #430
• 5a70b83: Fixed spelling and gramar README.md (Christian Kadluba) #430
• e9996f4: Updated CHANGES.md (Christian Kadluba) #430

What's Changed

• Updated .NET target frameworks (removed soon obsolete .NET Core 3.1, added .NET 6.0 LTS).
• Fixed issue #417: removed obsolete and vulnerable Microsoft.Azure.Services.AppAuthentication.
• Updated SqlClient to 5.0.1 (breaking change: https://github.com/serilog-mssql/serilog-sinks-mssqlserver#release-600).
• Updated all other dependencies to latest versions.
• Removed obsolete System.Config extension methods (only for .NET Framework 4.5.2 which is no longer supported).

Breaking Change

Microsoft.Data.SqlClient was upgraded to >4.0.0 which introduces a breaking change regarding connection strings. If your SQL Server does not use encryption you have to explicitly specify this in the connection string by adding Encrypt=False. Otherwise the connection will fail with a SqlException. Refer to the SqlClient documentation for details.

v5.8.0

What's Changed

• Partial fix of issue #417: Update SqlClient to 3.0.0 etc. to fix high severity vulnerability
• Removed support for obsolete .NET Framework 4.5.2
• Fixed issue #408: wrong sample in README

v5.7.1

Commits

• baea9ce: Update README.md (GhalamborM) #402
• 0cb0f33: GitHub Actions Build (Christian Kadluba) #402
• 1cc7112: Update main.yml (Christian Kadluba) #402
• 2d04cfa: Update main.yml (Christian Kadluba) #402
• 9e7a1ce: Update main.yml (Christian Kadluba) #402
• f954655: Update main.yml (Christian Kadluba) #402
• 5b502c6: GitHub actions (#387) (Christian Kadluba) #402
• 31c5bea: GitHub actions (#388) (Christian Kadluba) #402
• 609a1db: Update release.yml (Christian Kadluba) #402
• fc36030: Update release.yml (Christian Kadluba) #402
• 6fba8d6: Update release.yml (Christian Kadluba) #402
• 5030d18: Migration of MSSQL sink repo to new org (#389) (Christian Kadluba) #402
• 147237e: Small fixes in workflows (Christian Kadluba) #402
• 5523277: Made SkipTests in Build.ps1 a switch parameter. (Christian Kadluba) #402
• 66e6197: Made SkipTests in Build.ps1 a switch parameter (forgot to adapt call in WF file). (Christian Kadluba) #402
• eacbca6: Core implementation without config handling. (Christian Kadluba) #402
• ec41352: Read new sink option PreventEnlistInTransaction from all supported configuration sources. (Christian Kadluba) #402
• 40ab647: Run tests for all supported target frameworks of the sink (added missing net472). (Christian Kadluba) #402
• d7cbe54: Fixed timing dependent database test failures (EagerlyEmitFirstEvent = true). (Christian Kadluba) #402
• 2b0c9c8: Changes after review from @jonorossi. (Christian Kadluba) #402
• 557049d: Execute test LogsAreNotAffectedByTransactionsByDefault in a separate run from all other tests to avoid side effects with other DB tests. Ugly but the only feasible way to get this stable. (Christian Kadluba) #402
• edc036b: Ensured stability of DB tests. (Christian Kadluba) #402
• 7393fc1: Add trimming to rendered message and message template in case the database fields are smaller than the rendered text (studiopasokon) #402
• 8230a31: Add unit tests related to the trimming functionality (studiopasokon) #402
• 5c0b80f: Extend README.md with explanation about the trimming effect when the field lengths are set to a specific size (studiopasokon) #402
• 4cc02e0: Fix README.md encoding issue (studiopasokon) #402
• a4e6a87: Add missing forward tick so that the markdown is properly interpreted (studiopasokon) #402
• 01b5da0: Switch around maxAllowedMessageLength comparisons for better readability (studiopasokon) #402
• 083ea93: Add extra unit test to check with a custom defined length of -1, or maximum field length (studiopasokon) #402
• e995464: Rename tests truncating the message and message template from 'Trimmed' to 'Truncated' (studiopasokon) #402
• bcb4f6b: Add (slightly) general Truncate extension method (studiopasokon) #402
• c70b1b2: Improve truncating the log message, message template and add truncating the exception message (studiopasokon) #402
• e9c4cb3: Add note about truncating data of the Exception column, fix maximum value settings of the Message and MessageTemplate columns, and rename trimming to truncating (studiopasokon) #402
• 491791f: Update README.md (Endy Tjahjono) #402
• 4a80fd4: Release 5.7.1 (Christian Kadluba) #402

What's Changed

• Release 5.7.1 by @ckadluba in #402
• Exclude logging from DB transactions and added sink option EnlistInTransaction (thanks to @ @Daniel-Svensson for the idea and original PR).
• Fixed issue #209: Add trimming to rendered message and message template (thanks to @studiopasokon)
• Fixed documentation regarding supported .NET versions (thanks to @GhalamborM).
• Migrated sink to new GitHub and nuget.org organizations.
• Use GitHub Actions for build including automatic release documentation.

Full Changelog: v439...v5.7.1

v5.7.0

What's Changed

• Update README.md by @domagojmedo in #358
• Updated .NET target frameworks by @ckadluba in #361
• Add configurable tenant ID by @mattosaurus in #370
• Updated EOL .NET framework and README correction by @ckadluba in #371
• Fixed target framework dependent test includes by @ckadluba in #372
• Additional tests for Azure managed identity tennant Id. by @ckadluba in #373
• fix(logging): Fixed string formats in Selflog.WriteLine calls. by @sommmen in #382
• Changes for release 5.7.0 by @ckadluba in #383
• Release 5.7.0 by @ckadluba in #384

New Contributors

• @domagojmedo made their first contribution in #358
• @mattosaurus made their first contribution in #370
• @sommmen made their first contribution in #382

Full Changelog: v5.6.1...v439

v5.6.1

• Added support for reserved columns (thanks to @susanneschuster).
• Fixes in README.