Last post May 28, 2020 09:43 AM by Brando ZWZ
May 27, 2020 08:50 PMfirstname.lastname@example.org|LINK
how to create real time notification between sql server and wcf service it mean any change happen in sql server show imedately in wcf service?
May 28, 2020 09:43 AM|Brando ZWZ|LINK
According to your description, I suggest you could consider using SqlDependency.
A SqlDependency object can be associated with a SqlCommand in order to detect when query results differ from those originally retrieved. You can also assign a delegate to the OnChange event, which will fire when the results change for an associated command.
You must associate the SqlDependency with the command before you execute the command.
More details about how to use it in C# WCF, you could refer to below article.