Hangfire.SqlServer 1.7.30 The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org. Prefix Reserved

.NET Standard 1.3 .NET Framework 4.5
There is a newer prerelease version of this package available.
See the version list below for details.
Install-Package Hangfire.SqlServer -Version 1.7.30
dotnet add package Hangfire.SqlServer --version 1.7.30
<PackageReference Include="Hangfire.SqlServer" Version="1.7.30" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Hangfire.SqlServer --version 1.7.30
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Hangfire.SqlServer, 1.7.30"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Hangfire.SqlServer as a Cake Addin
#addin nuget:?package=Hangfire.SqlServer&version=1.7.30

// Install Hangfire.SqlServer as a Cake Tool
#tool nuget:?package=Hangfire.SqlServer&version=1.7.30
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

SQL Server 2008+ (including Express), SQL Server LocalDB and SQL Azure storage support for Hangfire (background job system for ASP.NET applications).

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
.NET Core netcoreapp1.0 netcoreapp1.1 netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard1.3 netstandard1.4 netstandard1.5 netstandard1.6 netstandard2.0 netstandard2.1
.NET Framework net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen30 tizen40 tizen60
Universal Windows Platform uap uap10.0
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (101)

Showing the top 5 NuGet packages that depend on Hangfire.SqlServer:

Package Downloads
Hangfire The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

An easy and reliable way to perform fire-and-forget, delayed and recurring, long-running, short-running, CPU or I/O intensive tasks inside ASP.NET applications. No Windows Service / Task Scheduler required. Even ASP.NET is not required. Backed by Redis, SQL Server, SQL Azure or MSMQ. This is a .NET alternative to Sidekiq, Resque and Celery. https://www.hangfire.io/

Hangfire.SqlServer.MSMQ The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

MSMQ queues support for SQL Server job storage implementation for Hangfire (background job system for ASP.NET applications).

Naos.MessageBus.Hangfire.Sender

Created on 2022-06-27 21:28

Naos.MessageBus.Hangfire.Harness

Created on 2022-06-27 21:28

Hangfire.Azure.ServiceBusQueue The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

Azure ServiceBus Queue support for SQL Server job storage implementation

GitHub repositories (17)

Showing the top 5 popular GitHub repositories that depend on Hangfire.SqlServer:

Repository Stars
abpframework/abp
Open Source Web Application Framework for ASP.NET Core
simplcommerce/SimplCommerce
A simple, cross platform, modularized ecommerce system built on .NET Core
elsa-workflows/elsa-core
A .NET Standard 2.0 Workflows Library
eventflow/EventFlow
Async/await first CQRS+ES and DDD framework for .NET
VirtoCommerce/vc-platform
VirtoCommerce Platform repository
Version Downloads Last updated
1.8.0-rc1 4,459 6/13/2022
1.8.0-beta4 99,721 11/12/2021
1.8.0-beta3 58,599 7/5/2021
1.8.0-beta2 14,419 4/15/2021
1.8.0-beta1 5,838 3/19/2021
1.7.30 290,199 6/10/2022
1.7.29 158,871 5/23/2022
1.7.28 1,999,565 12/18/2021
1.7.27 772,080 11/3/2021
1.7.26 120,667 10/27/2021
1.7.25 1,019,749 8/30/2021
1.7.24 1,171,979 6/28/2021
1.7.23 621,014 5/28/2021
1.7.22 976,251 4/13/2021
1.7.21 18,057 4/12/2021
1.7.20 399,078 3/19/2021
1.7.19 1,523,870 1/15/2021
1.7.18 1,106,011 11/20/2020
1.7.17 751,897 10/20/2020
1.7.16 138,861 10/14/2020
1.7.15 133,309 10/8/2020
1.7.14 312,534 9/24/2020
1.7.13 206,053 9/15/2020
1.7.12 992,439 7/24/2020
1.7.11 2,723,645 4/15/2020
1.7.10 324,941 4/2/2020
1.7.9 2,228,800 1/20/2020
1.7.8 871,090 12/5/2019
1.7.7 954,372 10/22/2019
1.7.6 1,620,553 8/5/2019
1.7.5 341,911 7/18/2019
1.7.4 397,962 6/28/2019
1.7.3 698,489 5/23/2019
1.7.2 438,232 4/29/2019
1.7.1 328,031 4/16/2019
1.7.0 346,915 3/29/2019
1.6.30 11,076 4/29/2021
1.6.29 46,679 4/15/2020
1.6.28 64,070 1/14/2020
1.6.27 59,069 6/27/2019
1.6.26 83,009 5/23/2019
1.6.25 14,278 4/9/2019
1.6.24 28,961 3/27/2019
1.6.23 236,641 3/13/2019
1.6.22 813,507 1/25/2019
1.6.21 1,104,953 11/1/2018
1.6.20 1,172,464 7/31/2018
1.6.19 1,382,850 4/6/2018
1.6.18 21,779 4/5/2018
1.6.17 1,677,031 9/19/2017
1.6.16 167,301 9/2/2017
1.6.15 248,321 8/8/2017
1.6.14 299,338 6/16/2017
1.6.13 68,939 6/7/2017
1.6.12 591,576 3/22/2017
1.6.11 38,364 3/14/2017
1.6.10 13,709 3/13/2017
1.6.9 53,636 3/2/2017
1.6.8 355,070 12/21/2016
1.6.7 173,304 11/25/2016
1.6.6 186,891 10/13/2016
1.6.5 113,509 9/24/2016
1.6.4 98,565 8/30/2016
1.6.3 40,809 8/19/2016
1.6.2 61,939 8/5/2016
1.6.1 71,480 7/27/2016
1.6.0 37,564 7/15/2016
1.5.9 191,412 7/11/2016
1.5.8 42,061 6/17/2016
1.5.7 28,845 5/30/2016
1.5.6 74,242 4/22/2016
1.5.5 22,478 4/14/2016
1.5.4 53,269 3/22/2016
1.5.3 309,271 11/6/2015
1.5.2 28,830 10/15/2015
1.5.1 2,977 10/14/2015
1.5.0 51,230 10/1/2015
1.4.7 2,698 10/1/2015
1.4.6 37,154 8/29/2015
1.4.5 37,788 7/24/2015
1.4.4 2,158 7/23/2015
1.4.3 71,216 5/27/2015
1.4.2 11,386 5/6/2015
1.4.1 24,914 4/14/2015
1.3.4 57,057 2/4/2015
1.3.3 3,515 1/28/2015
1.3.2 2,016 1/27/2015
1.3.1 7,378 1/13/2015
1.3.0 8,056 12/10/2014
1.2.2 18,149 11/24/2014
1.2.1 1,769 11/22/2014
1.2.0 4,938 11/17/2014
1.1.1 17,168 9/5/2014
1.1.0 2,713 9/3/2014
1.0.2 5,800 7/1/2014
1.0.1 1,643 6/30/2014
1.0.0 1,777 6/30/2014
0.9.1 2,903 6/12/2014
0.9.0 1,501 6/7/2014
0.8.3 1,522 5/23/2014
0.8.2 1,483 5/21/2014
0.8.1 2,545 5/17/2014
0.8.0 2,370 5/2/2014
0.7.5 1,590 4/10/2014
0.7.4 1,349 4/7/2014
0.7.3 1,347 4/4/2014
0.7.1 1,335 4/1/2014
0.7.0 3,325 3/22/2014

https://www.hangfire.io/blog/

Please see https://docs.hangfire.io/en/latest/upgrade-guides/upgrading-to-hangfire-1.7.html to learn how to upgrade from 1.6.X.

1.7.29
• Fixed – Command batching is now fully working for the Microsoft.Data.SqlClient package (by @0xced).

1.7.28
• Fixed – Possibly fixed CPU consumption problems and high amounts of fetching queries after deploys to IIS.
• Fixed – No more than a single long-polling query is allowed per storage instance when using sub-second polling.
• Fixed – Don't depend on thread pool when sending heartbeats for active jobs to avoid problems when it's starved.

1.7.25
• Fixed – Avoid any blocked rows when removing inactive servers from the `Server` table.

1.7.24
• Changed – Don't use the `readcommittedlock` table hint when not required.
• Project – Stop using `TransactionScope` class in tests, re-create database instead.
• Project – Make it possible to run SQL Server tests on Mono on Linux.

1.7.23
• Fixed – `NotImplementedException` in `Transaction.EnlistPromotableSinglePhase` when running on Mono.

1.7.21
• Fixed – Ensure connection is released when exception is thrown when during lock release.
• Fixed – "A network-related or instance-specific error" when using `DisableConcurrentExecution` for long-running jobs.

1.7.20

Please see https://www.hangfire.io/blog/2021/03/19/hangfire-1.7.20.html for details, manual changes
required for those who already migrated to Schema 6 and 7. This problem will be also fixed in a new
migration in Hangfire 1.8.0.

• Fixed – `Schema 6` migration now fixes problem that prevents 2,147,483,648th job from being enqueued.

1.7.19
• Fixed – Return `null` instead of throwing FormatException when job id can't be parsed.
• Project – Run the entire Hangfire.SqlServer test suite against the new Microsoft.Data.SqlClient package.

1.7.18
• Added – `SqlServerStorageOptions.DeleteExpiredBatchSize` option to remove more expired records in a single pass.
• Fixed – Don't throw from `SqlServerStorage.ToString` method when using custom factory or existing connection.

1.7.17
• Fixed – SqlException "Incorrect syntax near 'throw'" after upgrading to 1.7.15 when using SQL Server 2008 or 2008R2.

1.7.16
• Fixed – Blocking problems when using multiple storages with the same queue names in the same process (appeared in 1.7.9).

1.7.15
• Fixed – Avoid deadlocks when using the `SetJobParameter` method without introducing issues for older schemas.
• Fixed – Remove duplicate sorting in the `SqlServerMonitoringApi.GetJobs` method which is used by a lot of queries.

1.7.14
• Fixed – Duplicate entries in the `JobParameters` table after upgrading to version 1.7.13.
• Fixed – Extensive retries on a method that has a retry attribute after upgrading to 1.7.13.
• Fixed – "ArgumentException: An item with the same key has already been added. Key: RetryCount" in `SqlServerMonitoringApi`.

1.7.13
• Added – `UseIgnoreDupKeyOption` for SQL Server storage configuration (changes to [Set] and [Hash] tables required).
• Fixed – Don't truncate too long keys silently, throw exceptions instead.
• Fixed – Add missing null checks for methods in the `SqlServerWriteOnlyTransaction` class.
• Fixed – Change `holdlock` hint to `xlock` in `merge` statements in transaction to prevent deadlocks.
• Fixed – Don't rethrow "Lock request time out period exceeded" exceptions from expiration manager.
• Fixed – Increase [Server].[Id] column's length to 200 for new installations.

1.7.10
• Changed – Use `XACT_ABORT` option for `ExpirationManager` queries.
• Changed – Don't rely on implicit rollback when disposing transactions.
• Fixed – `NullReferenceException` in logs thrown from `SqlInternalTransaction.Rollback` method.

1.7.9
• Changed – Implement long polling fetch for sub-second polling delays without `sp_getapplock`.
• Fixed – Don't leak `DbConnection` instance when an exception occurs during its opening.
• Fixed – Can not obtain connection from the pool exception after database was offline.
• Fixed – High number of waits in SQL Server when Hangfire Servers are idle.

1.7.8
• Added – Support for Microsoft.Data.SqlClient package when using a custom connection factory (Part II).
• Fixed – Remove `System.Data.SqlClient` dependency from `SqlCommandBatch` and `ExpirationManager`.

1.7.7
• Added – Add support for Microsoft.Data.SqlClient package when using custom connection factory (Part I).
• Added – Add `UseFineGrainedLocks` option to avoid deadlocks in some theoretical cases.
• Added – Add missing overload for `UseSqlServerStorage` with connection factory parameter only.
• Added – Expose the SqlServerObjectsInstaller.GetInstallScript method (by @altso).
• Fixed – Make command batching working on .NET Core when using System.Data.SqlClient 4.7.0 and higher.
• Fixed – Permit dash characters (`-`) in schema names (by @kendaleiv).
• Fixed – Escape square bracket characters in schema names.
• Project – Add support for `netcoreapp3.0` target in Hangfire.SqlServer.Tests.
• Project – Take schema name from constant in Hangfire.SqlServer.Tests (by @kendaleiv).
• Project – Make Hangfire.SqlServer.Tests work on Linux in Travis CI environment.

1.7.4
• Fixed – Potential deadlocks cause by suboptimal queries when using `SlidingInvisibilityTimeout` fetching.
• Fixed – Prevent zero delays between fetch retry attempts when lock acquisition failed without blocking.
• Fixed – Specify float precision explicitly for the `Score` column in the `AddToSet` method.

1.7.3
• Fixed – Wrong error message in migration script, when @CurrentSchemaVersion has a NULL value (by @penenkel).

1.7.2
• Fixed – Occasional "DataException: Error parsing column" error when using blocking fetch.

1.7.1
• Changed – Use blocking fetch implementation only for sub-second polling intervals.
• Fixed – Don't fail with an exception when can't connect to MSSQL instance during start-up.
• Fixed – Don't access the `JobQueue` table when using blocking query and don't have results.

1.7.0
• Added – Full .NET Core 2.0 support by explicitly targeting .NET Standard 2.0.
• Added – `Schema 7` migration to fix the `IX_HangFire_Set_Score` index to include the `Key` column.
• Added – `Schema 6` migration with less indexes, better physical layout and `bigint` support (disabled by default).
• Added – Blocking fetch support for sliding expiration-based fetch to avoid excessive polling.
• Added – `SqlServerStorageOptions.EnableHeavyMigrations` switch to automatically install even heavy migrations.
• Added – `SqlServerStorageOptions.DisableGlobalLocks` property to avoid custom locking scheme.
• Added – `SqlServerStorageOptions.UsePageLocksOnDequeue` property to use less CPU consuming fetch.
• Added – Callback method to allow to open the database with impersonation (by @BjoernHund).
• Added – `SqlServerStorageOptions.UseRecommendedIsolationLevel` option to set the minimum possible level.
• Changed – Identity columns either converted to the `bigint` type, or entirely removed.
• Changed – Clustered indexes were organized according to the access patterns of their tables.
• Changed – Most of secondary indexes were either removed or made filtered.
• Changed – Optimize sliding-expiration-based fetching to use even less CPU time.
• Changed – Use write reordering and fine-grained locking scheme to improve parallelism.
• Changed – Monitoring API doesn't check state data to see state transition time.
• Changed – Allow to use zero-based poll interval when sliding invisibility timeout.
• Changed – Short paths for the `CreateExpiredJob` method to avoid some round-trips.
• Changed – Set `SqlParameter` types explicitly to not to duplicate query plans.
• Changed – Batch support for `AddToQueue` method when default provider is used.
• Changed – Check `FetchedAt` has expected value to prevent prolonging others' work.
• Changed – Use more recent Dapper 1.50.7 on all platforms except .NET Framework 4.5.
• Changed – Dapper package is internalized now even on .NET Core to avoid possible conflicts.
• Fixed – Avoid unnecessary waits in state changer when job was already expired.
• Fixed – Cannot resolve the collation conflict in `CountersAggregator`.
• Fixed – Background processing stops when identity columns exceed the `Int32.MaxValue`.
• Fixed – Slowdown of scheduled jobs due to the missing index on the `[Set]` table.