Adeotek.SqlDependencyListener
1.0.5
.NET Standard 2.0
dotnet add package Adeotek.SqlDependencyListener --version 1.0.5
NuGet\Install-Package Adeotek.SqlDependencyListener -Version 1.0.5
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="Adeotek.SqlDependencyListener" Version="1.0.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Adeotek.SqlDependencyListener --version 1.0.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Adeotek.SqlDependencyListener, 1.0.5"
#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 Adeotek.SqlDependencyListener as a Cake Addin
#addin nuget:?package=Adeotek.SqlDependencyListener&version=1.0.5
// Install Adeotek.SqlDependencyListener as a Cake Tool
#tool nuget:?package=Adeotek.SqlDependencyListener&version=1.0.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
.Net SqlDependencyListener
Simple System.Data.SqlClient.SqlDependency listener implementation
Installation
The Adeotek.SqlDependencyListener NuGet package can be found here. Alternatively you can install it via one of the following commands below:
NuGet command:
Install-Package Adeotek.SqlDependencyListener
.NET Core CLI:
dotnet add package Adeotek.SqlDependencyListener
Usage
With automatic database setup
var options = new SqlDependencyListenerOptions
{
CommandTimeout = 60000, // Optional (default 60000)
ManualConfiguration = false, // Required (false)
AutoEnableServiceBroker = true, // Optional (default false)
ListenerType = NotificationTypes.Insert | NotificationTypes.Update | NotificationTypes.Delete, // Optional
Identity = 1 // Optional (default 1)
//// Database objects naming options
QueueSchemaName = "dbo", // Optional (default "dbo")
QueueName = "TEST_NOTIFICATIONS_QUEUE",
ServiceName = "TEST_NOTIFICATIONS_SERVICE",
TriggerName = "TR_TEST_NOTIFICATIONS",
InstallProcedureName = "SP_INSTALL_TEST_NOTIFICATIONS",
UninstallProcedureName = "SP_UNINSTALL_TEST_NOTIFICATIONS"
};
var listener = new SqlDependencyListener<EventData<DataModel>>(
connectionString,
databaseName,
tableName,
databaseSchema,
options);
listener.OnTableChanged += OnTableChangedHandler;
listener.Start();
// ...
listener.Stop();
OnTableChanged example
void OnTableChangedHandler(object sender, TableChangedEventArgs<EventData<DataModel>> e)
{
Console.WriteLine("Event raw message (JSON): {0}", e.Message);
EventData<DataModel> data = e.Data;
}
With manual database setup
var options = new SqlDependencyListenerOptions
{
CommandTimeout = 60000, // Optional (default 60000)
ManualConfiguration = true, // Required (true)
QueueSchemaName = "dbo", // Optional (default "dbo")
QueueName = "TEST_NOTIFICATIONS_QUEUE" // Required
};
var listener = new SqlDependencyListener<CustomDataModel>(
connectionString,
databaseName,
tableName,
databaseSchema,
options);
listener.OnTableChanged += OnTableChangedHandler;
listener.Start();
// ...
listener.Stop();
OnTableChanged example
void OnTableChangedHandler(object sender, TableChangedEventArgs<CustomDataModel> e)
{
Console.WriteLine("Event raw message (JSON): {0}", e.Message);
CustomDataModel data = e.Data;
}
For complete usage example, please check the sample project.
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 net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows |
.NET Core | netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard2.0 netstandard2.1 |
.NET Framework | net461 net462 net463 net47 net471 net472 net48 net481 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
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.
-
.NETStandard 2.0
- Microsoft.Data.SqlClient (>= 4.1.0)
- System.Text.Json (>= 6.0.5)
-
.NETStandard 2.1
- Microsoft.Data.SqlClient (>= 4.1.0)
- System.Text.Json (>= 6.0.5)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.