I want to execute a code in c# whenever a new row is inserted in the database?

What you are describing is moving from a polling model to a publish/subscribe model (which as you can appreciate is a much better way to do chats/feeds than polling). Two possible resources are this article Publish/Subscribe design pattern implementation in C and this previous stack overflow question about Pub/Sub architecture .

I'll stay away from commenting on different methods of implementing your application and concentrate on answering the question you asked - you can accomplish this using Query Notifications. There is a lot you can do with these, but the basic premise is that once you have set this up, you give SQL server a query you are interested in, and it will notify your application when the results change.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions