Hangfire.SqlServer 1.8.0

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.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.