I run my c# app using SqlDependency with
“select productid, productname from dbo.products” and it works.
But when I have changed the query to “select productid, productname from dbo.productsMO” where ProductsMO is memory-optimized table then I do not receive notifications. What is the reason? How to wotk with MO tables?
Or may exists another framework to work with memory-optimized tables?