HangFire.SqlServer 1.7.15

The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org. Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
dotnet add package HangFire.SqlServer --version 1.7.15
NuGet\Install-Package HangFire.SqlServer -Version 1.7.15
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="HangFire.SqlServer" Version="1.7.15" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add HangFire.SqlServer --version 1.7.15
#r "nuget: HangFire.SqlServer, 1.7.15"
#r directive can be used in F# Interactive and Polyglot Notebooks. 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.15

// Install HangFire.SqlServer as a Cake Tool
#tool nuget:?package=HangFire.SqlServer&version=1.7.15

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

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

NuGet packages (133)

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/

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

Virto Commerce is a flexible B2B ecommerce solution that offers powerful tools for enterprise business users. https://virtocommerce.com

N3O.Umbraco.Scheduler

TODO

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, a background job framework for .NET applications.

Naos.MessageBus.Hangfire.Sender

Created on 2022-06-27 21:28

GitHub repositories (20)

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. Offers an opinionated architecture to build enterprise software solutions with best practices on top of the .NET and the ASP.NET Core platforms. Provides the fundamental infrastructure, production-ready startup templates, application modules, UI themes, tooling, guides and documentation.
dotnetcore/Util
Util是一个.Net平台下的应用框架,旨在提升中小团队的开发能力,由工具类、分层架构基类、Ui组件,配套代码生成模板,权限等组成。
simplcommerce/SimplCommerce
A simple, cross platform, modulith ecommerce system built on .NET
eventflow/EventFlow
Async/await first CQRS+ES and DDD framework for .NET
VirtoCommerce/vc-platform
Virto Commerce Platform Repository
Version Downloads Last updated
1.8.11 255,837 2/23/2024
1.8.10 154,114 2/12/2024
1.8.9 275,149 1/24/2024
1.8.7 422,466 12/29/2023
1.8.6 1,203,407 10/18/2023
1.8.5 1,307,650 8/11/2023
1.8.4 310,646 7/27/2023
1.8.3 680,605 6/27/2023
1.8.2 702,076 5/26/2023
1.8.1 195,224 5/18/2023
1.8.0 470,936 4/28/2023
1.7.36 193,570 6/29/2023
1.7.35 52,336 5/18/2023
1.7.34 761,118 3/30/2023
1.7.33 1,727,189 1/31/2023
1.7.32 1,932,785 11/21/2022
1.7.31 3,164,237 8/19/2022
1.7.30 2,120,063 6/10/2022
1.7.29 737,339 5/23/2022
1.7.28 5,767,584 12/18/2021
1.7.27 1,588,577 11/3/2021
1.7.26 233,689 10/27/2021
1.7.25 1,729,117 8/30/2021
1.7.24 1,889,329 6/28/2021
1.7.23 1,031,799 5/28/2021
1.7.22 1,458,858 4/13/2021
1.7.21 25,428 4/12/2021
1.7.20 643,206 3/19/2021
1.7.19 2,112,042 1/15/2021
1.7.18 1,458,556 11/20/2020
1.7.17 1,039,926 10/20/2020
1.7.16 194,735 10/14/2020
1.7.15 179,797 10/8/2020
1.7.14 690,126 9/24/2020
1.7.13 265,630 9/15/2020
1.7.12 1,313,322 7/24/2020
1.7.11 3,713,416 4/15/2020
1.7.10 435,799 4/2/2020
1.7.9 3,114,769 1/20/2020
1.7.8 1,113,630 12/5/2019
1.7.7 1,171,752 10/22/2019
1.7.6 1,987,347 8/5/2019
1.7.5 433,801 7/18/2019
1.7.4 502,140 6/28/2019
1.7.3 872,747 5/23/2019
1.7.2 507,463 4/29/2019
1.7.1 471,464 4/16/2019
1.7.0 450,129 3/29/2019
1.6.30 38,875 4/29/2021
1.6.29 84,510 4/15/2020
1.6.28 81,355 1/14/2020
1.6.27 67,285 6/27/2019
1.6.26 90,460 5/23/2019
1.6.25 23,089 4/9/2019
1.6.24 121,043 3/27/2019
1.6.23 269,468 3/13/2019
1.6.22 932,068 1/25/2019
1.6.21 1,283,795 11/1/2018
1.6.20 1,605,994 7/31/2018
1.6.19 1,581,651 4/6/2018
1.6.18 30,881 4/5/2018
1.6.17 1,941,223 9/19/2017
1.6.16 212,123 9/2/2017
1.6.15 305,895 8/8/2017
1.6.14 360,210 6/16/2017
1.6.13 82,417 6/7/2017
1.6.12 703,568 3/22/2017
1.6.11 47,119 3/14/2017
1.6.10 18,453 3/13/2017
1.6.9 69,039 3/2/2017
1.6.8 425,406 12/21/2016
1.6.7 215,575 11/25/2016
1.6.6 230,888 10/13/2016
1.6.5 128,738 9/24/2016
1.6.4 111,020 8/30/2016
1.6.3 48,172 8/19/2016
1.6.2 73,869 8/5/2016
1.6.1 107,423 7/27/2016
1.6.0 52,221 7/15/2016
1.5.9 314,307 7/11/2016
1.5.8 59,188 6/17/2016
1.5.7 36,312 5/30/2016
1.5.6 88,728 4/22/2016
1.5.5 27,985 4/14/2016
1.5.4 64,825 3/22/2016
1.5.3 354,333 11/6/2015
1.5.2 38,228 10/15/2015
1.5.1 6,751 10/14/2015
1.5.0 64,597 10/1/2015
1.4.7 6,550 10/1/2015
1.4.6 56,323 8/29/2015
1.4.5 51,002 7/24/2015
1.4.4 5,979 7/23/2015
1.4.3 88,994 5/27/2015
1.4.2 15,217 5/6/2015
1.4.1 35,232 4/14/2015
1.3.4 66,137 2/4/2015
1.3.3 8,622 1/28/2015
1.3.2 5,899 1/27/2015
1.3.1 11,301 1/13/2015
1.3.0 12,259 12/10/2014
1.2.2 33,742 11/24/2014
1.2.1 5,906 11/22/2014
1.2.0 9,258 11/17/2014
1.1.1 22,949 9/5/2014
1.1.0 7,234 9/3/2014
1.0.2 10,219 7/1/2014
1.0.1 6,023 6/30/2014
1.0.0 6,219 6/30/2014
0.9.1 7,476 6/12/2014
0.9.0 5,715 6/7/2014
0.8.3 5,914 5/23/2014
0.8.2 5,688 5/21/2014
0.8.1 7,412 5/17/2014
0.8.0 6,255 5/2/2014
0.7.5 5,850 4/10/2014
0.7.4 5,152 4/7/2014
0.7.3 4,955 4/4/2014
0.7.1 5,464 4/1/2014
0.7.0 10,441 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.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.