Enable asp.net polling, DOT NET Programming

Assignment Help:

How to Enable ASP.NET polling?

All our database side is configured in order to get the SQL Cache working in the ASP.NET side we require to do some configuration in the web.config file.

The 2 attributes are require to set in the "web.config" file:-

  • Set the "Enabled" attribute to true to set the caching on.
  • Set the poll time attribute to the number of milliseconds between every poll

2415_asp.net polling.png

Figure :- Web.config file modifications for SQL cache

At last use the Cache dependency object in your ASP.NET code.

After that comes the final step to use our cache dependency with programmatic data caching,output caching  and data source control, .

For the programmatic data caching, we have to create a new SqlCacheDependency &  supply that to the Cache.Insert() process .  In the SqlCacheDependency constructor, you supply 2 strings. The first is the name of the database you defined in the element in the part of the web.config file e.g: Northwind. The second is the name of the linked table example: Products.

private static void CacheProductsList(List products) {SqlCacheDependency sqlDependency = new SqlCacheDependency("Northwind", "Products");

HttpContext.Current.Cache.Insert("ProductsList", products, sqlDependency, DateTime.Now.AddDays(1), Cache.NoSlidingExpiration);}

private static List GetCachedProductList()

{return HttpContext.Current.Cache["ProductsList"] as List;}

ClsProductItem is business class, and here we are trying to cache a list of ClsProductItem instead of DataSet or DataTable.

The following method is used by an ObjectDataSource Control to retrieve List of Products

 public static List GetProductsList(int catId, string sortBy)

{

//Try to Get Products List from the Cache

List products = GetCachedProductList();

if (products == null)

{

//Products List not in the cache, so query the Database layer

ClsProductsDB db = new ClsProductsDB(_connectionString);

DbDataReader reader = null;

products = new List(80);

if (catId > 0)

{

//Return Product List from the Data Layer

reader = db.GetProductsList(catId);

}

else {

//Return Product List from the Data Layer

reader = db.GetProductsList();

}

//Create List of Products -List if ClsProductItem-products = BuildProductsList(reader);

reader.Close();

//Add entry to products list in the Cache CacheProductsList(products); }

products.Sort(new ClsProductItemComparer(sortBy));

if (sortBy.Contains("DESC")) products.Reverse();

return products; }

To perform the same trick with output caching, you simply need to set the SqlDependency property with the database dependency name and the table name, separated by a colon:

<%@ OutputCache Duration="600" SqlDependency="Northwind:Products" VaryByParam="none" %>

The same technique works with the SqlDataSource and ObjectDataSource controls:

 


Related Discussions:- Enable asp.net polling

I need cloudflare api interface to c#, I need CloudFlare API interface to C...

I need CloudFlare API interface to C# Project Description: We require a small piece of C# .NET code, integrated in an object, that will interface with CloudFlare's API and ge

Daemon threads, What are Daemon threads? Daemon thread's run in the bac...

What are Daemon threads? Daemon thread's run in the background and stop automatically when nothing is running program. The Example of a Daemon thread is the "Garbage collector"

A super-hero sharepoint developer with great design skills, A Super-hero Sh...

A Super-hero Sharepoint developer with great design skills Project Description: US: Our start-up company develops a very cool and innovative SharePoint related product with c

Explain keywords with example, Explain keywords with example. Keywords...

Explain keywords with example. Keywords are those words that are reserved to be used for an exact task. These words cannot be used as identifiers. You cannot use a keyword to

What is a node, What is a node? A network can have of two or more compu...

What is a node? A network can have of two or more computers directly linked by some physical medium such as coaxial cable or optical fiber. Such a physical medium is known as L

Name the proxy file to use a web service., Mention the name of the director...

Mention the name of the directory where it is essential to locate the proxy file to use a Web service. The proxy file must be kept in the /bin directory. This directory is situ

Required c# programmer, The program is broke now but explains in text and p...

The program is broke now but explains in text and printscreens the specific things i have to do to implement new bookies new sports and change settings for looking for arbs on two

Difference b/w msml and .net framework xml classes, What is the main differ...

What is the main difference b/w MSML and .NET Framework XML classes? The MSXML supports XML DOM and SAX parsers while the .NET framework XML classes support XML DOM and XML rea

Extensible markup language (xml), What is XML? Extensible markup langua...

What is XML? Extensible markup language (XML) is all about describing the data. Below is a XML which describes an invoice data. Shoes   12 10

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd