如何从SQL Server发出c＃控制台应用程序的信号？

Rather than poll against some tables, I'd like to signal a waiting c# app that there are new rows to be processed in a table, maybe via a trigger. Is there some way for the database to signal to a console app, or am I stuck polling the table looking for new rows?Rather than poll against some tables, I'd like