HangFire.SqlServer
1.7.8
SQL Server 2008+ (including Express), SQL Server LocalDB and SQL Azure storage support for Hangfire (background job system for ASP.NET applications).
Install-Package HangFire.SqlServer -Version 1.7.8
dotnet add package HangFire.SqlServer --version 1.7.8
<PackageReference Include="HangFire.SqlServer" Version="1.7.8" />
paket add HangFire.SqlServer --version 1.7.8
Release Notes
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.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.
Dependencies
-
.NETFramework 4.5
- Hangfire.Core (= 1.7.8)
-
.NETStandard 1.3
- Hangfire.Core (= 1.7.8)
- NETStandard.Library (>= 1.6.0)
- System.Data.Common (>= 4.1.0)
- System.Data.SqlClient (>= 4.1.0)
-
.NETStandard 2.0
- Hangfire.Core (= 1.7.8)
- System.Data.SqlClient (>= 4.4.0)
GitHub Usage
Showing the top 9 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
|
||
eventflow/EventFlow
Async/await first CQRS+ES and DDD framework for .NET
|
||
HTBox/allReady
This repo contains the code for allReady, an open-source solution focused on increasing awareness, efficiency and impact of preparedness campaigns as they are delivered by humanitarian and disaster response organizations in local communities.
|
||
Jimmey-Jiang/ABP-ASP.NET-Boilerplate-Project-CMS
ABP module-zero +AdminLTE+Bootstrap Table+jQuery+Redis + sql server+quartz+hangfire权限管理系统
|
||
yuzd/Hangfire.HttpJob
httpjob for Hangfire,restful api for Hangfire,job调度与业务分离
|
||
trueai-org/module-shop
一个基于 .NET Core构建的简单、跨平台、模块化的商城系统
|
||
stoveproject/Stove
Domain Driven Design oriented application framework, meets CRUD needs
|
||
bit-foundation/bit-framework
Full stack dev framework for C# / TypeScript / JavaScript developers
|
Version History
Version | Downloads | Last updated | ||
---|---|---|---|---|
1.7.8 | 0 | 12/5/2019 | ||
1.7.7 | 96,173 | 10/22/2019 | ||
1.7.6 | 396,045 | 8/5/2019 | ||
1.7.5 | 84,202 | 7/18/2019 | ||
1.7.4 | 138,119 | 6/28/2019 | ||
1.7.3 | 238,811 | 5/23/2019 | ||
1.7.2 | 183,811 | 4/29/2019 | ||
1.7.1 | 101,613 | 4/16/2019 | ||
1.7.0 | 163,438 | 3/29/2019 | ||
1.6.27 | 8,374 | 6/27/2019 | ||
1.6.26 | 13,525 | 5/23/2019 | ||
1.6.25 | 5,719 | 4/9/2019 | ||
1.6.24 | 17,051 | 3/27/2019 | ||
1.6.23 | 134,517 | 3/13/2019 | ||
1.6.22 | 430,315 | 1/25/2019 | ||
1.6.21 | 524,398 | 11/1/2018 | ||
1.6.20 | 616,871 | 7/31/2018 | ||
1.6.19 | 789,472 | 4/6/2018 | ||
1.6.18 | 9,352 | 4/5/2018 | ||
1.6.17 | 1,122,778 | 9/19/2017 | ||
1.6.16 | 88,257 | 9/2/2017 | ||
1.6.15 | 158,750 | 8/8/2017 | ||
1.6.14 | 221,847 | 6/16/2017 | ||
1.6.13 | 45,942 | 6/7/2017 | ||
1.6.12 | 402,918 | 3/22/2017 | ||
1.6.11 | 24,301 | 3/14/2017 | ||
1.6.10 | 11,543 | 3/13/2017 | ||
1.6.9 | 33,296 | 3/2/2017 | ||
1.6.8 | 234,119 | 12/21/2016 | ||
1.6.7 | 91,381 | 11/25/2016 | ||
1.6.6 | 129,658 | 10/13/2016 | ||
1.6.5 | 95,123 | 9/24/2016 | ||
1.6.4 | 79,173 | 8/30/2016 | ||
1.6.3 | 28,559 | 8/19/2016 | ||
1.6.2 | 47,355 | 8/5/2016 | ||
1.6.1 | 30,210 | 7/27/2016 | ||
1.6.0 | 19,431 | 7/15/2016 | ||
1.5.9 | 32,064 | 7/11/2016 | ||
1.5.8 | 30,600 | 6/17/2016 | ||
1.5.7 | 21,478 | 5/30/2016 | ||
1.5.6 | 57,046 | 4/22/2016 | ||
1.5.5 | 14,752 | 4/14/2016 | ||
1.5.4 | 36,162 | 3/22/2016 | ||
1.5.3 | 219,385 | 11/6/2015 | ||
1.5.2 | 22,715 | 10/15/2015 | ||
1.5.1 | 2,004 | 10/14/2015 | ||
1.5.0 | 26,924 | 10/1/2015 | ||
1.4.7 | 1,627 | 10/1/2015 | ||
1.4.6 | 21,203 | 8/29/2015 | ||
1.4.5 | 26,593 | 7/24/2015 | ||
1.4.4 | 906 | 7/23/2015 | ||
1.4.3 | 30,436 | 5/27/2015 | ||
1.4.2 | 9,336 | 5/6/2015 | ||
1.4.1 | 15,865 | 4/14/2015 | ||
1.3.4 | 46,327 | 2/4/2015 | ||
1.3.3 | 2,417 | 1/28/2015 | ||
1.3.2 | 978 | 1/27/2015 | ||
1.3.1 | 6,172 | 1/13/2015 | ||
1.3.0 | 4,710 | 12/10/2014 | ||
1.2.2 | 7,162 | 11/24/2014 | ||
1.2.1 | 662 | 11/22/2014 | ||
1.2.0 | 3,794 | 11/17/2014 | ||
1.1.1 | 14,187 | 9/5/2014 | ||
1.1.0 | 1,620 | 9/3/2014 | ||
1.0.2 | 4,469 | 7/1/2014 | ||
1.0.1 | 570 | 6/30/2014 | ||
1.0.0 | 644 | 6/30/2014 | ||
0.9.1 | 1,651 | 6/12/2014 | ||
0.9.0 | 577 | 6/7/2014 | ||
0.8.3 | 603 | 5/23/2014 | ||
0.8.2 | 533 | 5/21/2014 | ||
0.8.1 | 1,088 | 5/17/2014 | ||
0.8.0 | 1,473 | 5/2/2014 | ||
0.7.5 | 520 | 4/10/2014 | ||
0.7.4 | 459 | 4/7/2014 | ||
0.7.3 | 461 | 4/4/2014 | ||
0.7.1 | 455 | 4/1/2014 | ||
0.7.0 | 1,422 | 3/22/2014 |