monitor-table-change-with-sqltabledependency

monitor-table-change-with-sqltabledependency copied to clipboard

My class: ``` public class ServiceIngenerJournal { public int ID { get; set; } public bool state { get; set; } public DateTime? dt { get; set; } public int?...

IichiKohuro

I have implemented Table Depedendy in my code. It works fine but after some time it does not work. It doesn't call the OnChanged event. I need to restart the...

viveknuna

I have a design question. I'm in Azure DevOps pipeline and I need to run pipeline step using sqlcmd.exe (using cmd or PowerShell) to insert a record into a table...

rodsantest1

The event object always returns null. For example in your code example for Blazor, the event defined as public event WeatherForecastDelegate OnWeatherForecastChanged; the event OnWeatherForecastChanged always returns null and the...

B6692

SqlTbleDependency.Start() this method gives the error POISON_MESSAGE_HANDLING

hardik2015

Returning dynamic Object / ExpandoObject

1

Would it be somehow doable to pass "ExpandoObject" as a model? I'm working with a completely dynamic database structure and have no way to know how the table will be...

arvenyon

Not dropped trigger with not existing conversation handle blocks all DML operations

8

Hi, when the trigger is trying to drop itself, combined with the conversation_cursor, it "locks" all upcoming DML operations and the trigger is not dropped: The DML operations are failing...

tomasfabian

Hi if I have a class public Class1 { string prop1{get; set;} string prop2{get; set;} Class2 prop3{get; set;} } public Class2 { string prop1{get; set;} string prop2{get; set;} } Then...

GrazDeKa

sqltabledependency trigger on my table “locks” all upcoming DML operations

4

Hi, I enable Service Broker on my sql server 2012 to use sqltabledependency in vb.net application to notify me on update a field. but recently I saw a trigger on...

hdamis

Hi, I am trying to set a notification if there is a new entry in the service broker queue. I am using the schema name 'dbo' for the queue. But...

sharmaashish52