Cache object is always null in SQLServer Cache Dependency

[Resolved]

You might look at several other possibilities however just make sure that your table name into the SQL Statement is of two part. So in case your database table name is "PersonalDetail" your SQL statement should look like

SELECT AutoId, FirstName, LastName, Age, Active FROM [dbo]. PersonalDetail ORDER By AutoId

Not

SELECT AutoId, FirstName, LastName, Age, Active FROM PersonalDetail ORDER By AutoId

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com