Com.H.Threading.Scheduler.VP.Sql
10.0.0
dotnet add package Com.H.Threading.Scheduler.VP.Sql --version 10.0.0
NuGet\Install-Package Com.H.Threading.Scheduler.VP.Sql -Version 10.0.0
<PackageReference Include="Com.H.Threading.Scheduler.VP.Sql" Version="10.0.0" />
<PackageVersion Include="Com.H.Threading.Scheduler.VP.Sql" Version="10.0.0" />
<PackageReference Include="Com.H.Threading.Scheduler.VP.Sql" />
paket add Com.H.Threading.Scheduler.VP.Sql --version 10.0.0
#r "nuget: Com.H.Threading.Scheduler.VP.Sql, 10.0.0"
#:package Com.H.Threading.Scheduler.VP.Sql@10.0.0
#addin nuget:?package=Com.H.Threading.Scheduler.VP.Sql&version=10.0.0
#tool nuget:?package=Com.H.Threading.Scheduler.VP.Sql&version=10.0.0
Com.H.Threading.Scheduler.VP.Sql
A SQL Server value processor plug-in for Com.H.Threading.Scheduler.
Adds a sql content type that lets any XML tag in the scheduler config — including <repeat> — execute a live SQL Server query and use the results as dynamic data, fully integrated with the scheduler's variable substitution, chaining, and caching pipeline.
Quick example
<task>
<sys>
<time>08:00</time>
<repeat content_type="sql"
connection_string="Server=myserver;Database=mydb;Integrated Security=True"
delay_interval="200">
SELECT id, name, email FROM users WHERE active = 1
</repeat>
</sys>
<message>Sending report to {var{name}} at {var{email}}</message>
</task>
using Com.H.Threading.Scheduler.VP.Sql;
scheduler.AddValueProcessor(new SqlValueProcessor());
scheduler.TaskIsDue += async (object sender, HTaskEventArgs e, CancellationToken ct) =>
{
Console.WriteLine(e["message"]);
};
For full documentation and examples, visit the GitHub repository.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. 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. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net10.0
- Com.H (>= 10.1.0)
- Com.H.Data.Common (>= 10.1.0.4)
- Com.H.Threading.Scheduler (>= 10.0.1)
- Microsoft.Data.SqlClient (>= 7.0.0)
-
net8.0
- Com.H (>= 10.1.0)
- Com.H.Data.Common (>= 10.1.0.4)
- Com.H.Threading.Scheduler (>= 10.0.1)
- Microsoft.Data.SqlClient (>= 7.0.0)
-
net9.0
- Com.H (>= 10.1.0)
- Com.H.Data.Common (>= 10.1.0.4)
- Com.H.Threading.Scheduler (>= 10.0.1)
- Microsoft.Data.SqlClient (>= 7.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Added net9.0 and net10.0 targets; updated to use Com.H.Data.Common async API with native cancellation support; embedded debug symbols for source stepping