Cache Using ObjectDataSource

by rbellantoni 8/26/2010 7:02:00 AM

I needed to bind a large dataset to a gridview, it also contained numerous calculations that slowed down the database call, so I wanted to implement caching for the gridview I was using. 

So I used the default Caching on the ObjectDataSource. Which works great and well except for when you want to programatically refresh the data (say a new filter to be added). Turns out you can actually do it.

 

First make sure that in Page Load you set the CacheKeyDependency if it isn't set (you can also manually set it on the aspx page as a property of the ObjectDataSource):

        if (!IsPostBack)
        {
            //Create CacheKeyDependency if it doesn'tnot exists
            if (Cache[ObjectDataSource1.CacheKeyDependency] == null)
            {
                Cache[ObjectDataSource1.CacheKeyDependency] = new object();
            }
        }

In your code whenever you want the Select() of your ObjectDataSource to fire or just rebind from the database make this call:

Cache[ObjectDataSource1.CacheKeyDependency] = new object(); 

This allows you to programatically renew/refresh your datasource at will while still retaining the Cache abilities for paging/sorting/grouping etc.

Tags:

.NET | .NET WCF | BlogEngine.NET | SQL SERVER

Calling wcf service from Winform the operation has timed out

by ebarcza 4/1/2010 11:47:00 AM

I created a basic WCF service in a C# .NET web site. I was trying to connect to it via a web reference from a Winforms app with no luck. I kept on getting an error message "the operation has timed out"

The fix - use basic binding in the endpoint configuration

EX:
<service behaviorConfiguration="MyBehavior" name="MyNameSpace">
    <endpoint address="basic" binding="basicHttpBinding" contract="MyContract"><BR>
     <identity><BR>
      <dns value="localhost" /><BR>
     </identity><BR>
    </endpoint><BR>
    <endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" /><BR>
</service>

 
Voila - no more timeout - Give it a swirl!

Tags: , ,

.NET WCF

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen

About the author

Name of author Author name
Something about me and what I do.

E-mail me Send mail

Calendar

<<  September 2017  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

View posts in large calendar

Recent comments

Tags

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2017

Sign in