Hi,

I have read some atricles on Hoe sql cache dependency works.actually what i have under stood is as follows:

when we create sqldependency for table properly,once any changes occurs in that table will be automatically pushed to front end.so that we need not to hit the database again and again to fetch latest records.

i would like to know whether my understading on sql cache dependency is correct ot not. please correct me if i am wrong.

i would like to know the drawbacks of sql cache dependency. please