Serilog Sinks Mssqlserver Versions Save

• Fixed issue #509: Add SqlInsertStatementWriter which uses INSERT statements instead of SqlBulkCopy (thanks to @BrettJaner)

• Fixed issue #517: Updated Microsoft.Data.SqlClient to 5.1.5 to fix CVE-2024-21319

• Fixed issue #505: NVarChar Columns with 1 data length gets their values truncated into empty strings (thanks to @Whinarn)
• Updated Microsoft.Data.SqlClient to 5.1.4 to fix CVE-2024-0056 (https://github.com/advisories/GHSA-98g6-xh36-x2p7)

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

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

• Implemented #360: Automatic DB creation

• 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

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

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.

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