I have a database which is very frequently updated .I want an option that user can specify that after how many minutes he/she wants to see those changes . Like a mechanism which would do

1. Poll database after a user defined period and then bring those changes ,mean while displaying the stale data (like Cache )
2. Also allow user to choose if he/she wants to see/notify updates as they come
3. Can notify change ( if any ) in a particular table occur

I have read a lot about SQLDependency class which is used to data caching .The reason I am confused is

1. The recommendations are that don’t use this feature if your data is frequently updating (in my case data is frequently updating)
2. The class does Cache data for me but I cant find any mechanism which would notify me that a change has occurred and how many row in a particular table are added.

I am confused .What feature I should used . Should SQLDependency class can do the things I want or these can be done without SQLDependency Cache feature .

Please advice.