Hangfire.SqlServer 1.8.6

Release notes are available in our blog https://www.hangfire.io/blog/ Please see https://docs.hangfire.io/en/latest/upgrade-guides/upgrading-to-hangfire-1.8.html to learn how to upgrade. 1.8.6 • Fixed – Exception in Dashboard UI when schema version is not present in a database. • Fixed – `DbCommand` resource leak when releasing a lock detected by static analysis. • Fixed – Don't add SQL Server-related metrics multiple times in Dashboard UI. 1.8.5 • Fixed – "Query processor could not produce a query plan" when removing expired counters in `Schema 5`. 1.8.2 • Fixed – `InvalidOperationException` with new dashboard metrics when a database has multiple data/log files. 1.8.1 • Fixed – Blocked workers regression since 1.7.33 when using multiple servers inside a process. • Fixed – Target schema version is less than the current schema version error. • Fixed – Implement database metrics without the need for additional permissions. • Fixed – Use the `forceseek` table hint whenever possible to avoid performance drops. 1.8.0 • Breaking – Prioritise Microsoft.Data.SqlClient package over System.Data.SqlClient one. • Breaking – Dropped the `NET45` platform target in favor of the `NET451` target to support Visual Studio 2022. • Added – `Schema 8` migration with fixed `JobQueue.Id` column to use the `bigint` type. • Added – `Schema 9` migration that creates an index for the `State.CreatedAt` column. • Added – Automatic client package detection based on available types, preferring `System.Data.SqlClient` (by @0xced). • Added – `SqlServerStorageOptions.DbProviderFactory` option to use a custom provider factory. • Added – Clean up of old state entries of a non-finished job when `InactiveStateExpirationTimeout` is set. • Added – `TryAutoDetectSchemaDependentOptions` option to automatically enable options based on the schema. • Added – Optional experimental transactional acknowledge for SQL Server (`UseTransactionalAcknowledge` option). • Added – Implement the `Connection.GetUtcDateTime` feature to make work the new changes in schedulers. • Added – `SqlServerStorage.SchemaVersion` metric for Dashboard UI. • Added – `DefaultQueueProvider` option to specify a custom default queue provider. • Changed – Remove dependency on System.Data.SqlClient for Hangfire.SqlServer (by @0xced). • Changed – Set default value for the `QueuePollInterval` option to `TimeSpan.Zero`. • Changed – Polling delay when `QueuePollInterval` is set to zero now defaults to 200 ms. • Changed – Sliding invisibility timeout-based fetching method is now used by default with a 5-minute timeout. • Changed – Use command batching by default with a 5-minute maximum timeout. • Changed – Enable the `UseRecommendedIsolationLevel` option by default. • Changed – `GetJobData` now populates the `JobData.ParametersSnapshot` property to avoid additional roundtrips. • Changed – Display scheduled and processing jobs in ascending order in Dashboard UI. • Changed – Implement the `Transaction.AcquireDistributedLock` feature. • Changed – Implement the `GetSetCount.Limited feature`. • Changed – Implement the `GetSetContains feature`. • Changed – Bump the internal version of Dapper to 2.0.123. • Changed – Enable common metrics for SQL Server storage to be shown by default. • Changed – Enable the `Monitoring.AwaitingJobs` feature for SQL storage. • Deprecated – `UsePageLocksOnDequeue` option is now obsolete and doesn't affect anything.