While i perfrom sqlcache dependency i got the dependency polling error

Koteswararao Mallisetti

i am using the following code to achieve the sqlcache dependency but i got the error that is Unable to connect to SQL database 'koti' for cache dependency polling. in the sqlCacheDependency statement and i give the web.config setting as follows
if (Cache["states"] == null)
{
// Create the cache dependency

SqlCacheDependency dep = new SqlCacheDependency("koti", "states");

string connectionString =ConfigurationManager .ConnectionStrings[
"constrkoti"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionString);
SqlDataAdapter ad = new SqlDataAdapter("SELECT * from states", myConnection);
DataSet ds2 = new DataSet();
ad.Fill(ds2);
Label2.Text = "data is comming from database";
Cache.Insert("states", ds2, dep);
}

we.config:-

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anuja Pawar14y ago
Hi refer this article, hope it helps

http://www.dotnetcurry.com/ShowArticle.aspx?ID=263
0
Jignesh Trivedi14y ago
Hi,

try with SQLCommand Object..

using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(commandText, conn);
                    SqlCacheDependencyAdmin.EnableNotifications(connectionString);
                   //retrieve you tables..
                    SqlCacheDependency dependency = new SqlCacheDependency(cmd);
                    cmd.ExecuteNonQuery();
                    // Add your data into your cache object.

                    }
Hope this help.
0