monitor-table-change-with-sqltabledependency
monitor-table-change-with-sqltabledependency copied to clipboard
Text column type is not an supperted by SqlTableDependency
My class:
public class ServiceIngenerJournal
{
public int ID { get; set; }
public bool state { get; set; }
public DateTime? dt { get; set; }
public int? numobject { get; set; }
public string dopinfo { get; set; }
public int? statecell { get; set; }
public string nameaddress { get; set; }
public string prefix { get; set; }
public string comments { get; set; }
public bool? isSirenOn { get; set; }
}
Main code:
SqlTableDependency<ServiceIngenerJournal> dep;
private static List<ServiceIngenerJournal> entities;
private void Start()
{
try
{
dep = new SqlTableDependency<ServiceIngenerJournal>(journalsDbConnString, "ServiceIngenerJournal");
dep.OnChanged += Changed;
dep.Start();
}
catch (Exception ex)
{
// throw here
Console.WriteLine(ex.Message);
}
}