IsNemoEqualTrue/monitor-table-change-with-sqltabledependency

Text column type is not an supperted by SqlTableDependency

IichiKohuro opened this issue · 0 comments

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); 
	}
}