I found that it's possible to create server trigger from C# code.
But still can't find is it possible and how to subscribe to Server triggers or maybe design events based on sql server data change?
I think I can create an trigger on C# that will contact with my application with ... WCF? or somehow else, it should be not hard I think to create connection for C# -> C# there but is there examples, more native ways of catching sql server events from C# application?