Linq issue

[princesszea]

Hi,

Using the code below can someone please show me how to cache my query below.

  var query = from row in dt.AsEnumerable()
                        group row by row["name"] into grp

                        let totalcount = dt.AsEnumerable().Count()

                        select new
                        {
                            Id = grp.Key,
                            Count = grp.Count(),
                            TotalCount = totalcount,
                            Ratio = grp.Count() / totalcount

                        }
                  

            foreach (var grp in query)
            {
                int Count = grp.Count;
                int TotalCount = grp.TotalCount;
                int value = Count * 100 / TotalCount;

            }

Thanks

 

[jmeckley]

you wouldn't cache the linq object/statement, you would cache the results. How you cache can be done any number of ways. I would recommend a caching library, rather than rolling your own. here are some:
asp.net syscache and syscache2
memcached
bamboo prevalence
velocity


Jason Meckley
Programmer

faq855-7190
faq732-7259