how to cache a query result in asp.net mvc application

Question

my controller's methods uses the same query result to return various result (Jsonresult,actionresult) is there a way to cache the result in memory so that there is only one trip to data base for all controller methods so instead of executing the query the methods uses the result in cache

the variable that i want to cache is var x = from cus in db.BIOBillPh( )

    public ActionResult BillPhp(string CodePays)
    {
        var x = from cus in db.BIOBillPh( )

                select cus;
        return PartialView(x);

    }


    public JsonResult PaysBU(string  Pays)
    {


        var x = from cus in db.BIOBillPh()
                select cus;
        return Json(x, JsonRequestBehavior.AllowGet);
    }

There are any number of cache strategies available to you. What have you already tried so far? — 48klocs
– 48klocs, Commented Jun 11, 2014 at 14:26
i used outputcaching, but the problem is that i want the methods to share the same data result so that the query is executed only once — user3489866
– user3489866, Commented Jun 11, 2014 at 14:31
You have some more reading to do on the lifetime of cache strategies. The output cache is limited to a request/response stream. — 48klocs
– 48klocs, Commented Jun 11, 2014 at 17:25

Nick__Dudas · Accepted Answer · 2014-06-11 14:54:22Z

1

Controller instances are created on every call so not really. You could create an static interim object within your controller that would have some life span before refreshing db calls. Is this an action that's called with high frequency? The marginal, if any reduction in overhead might not be worth your time.

answered Jun 11, 2014 at 14:54

Nick__Dudas

9061 gold badge7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3489866 Over a year ago

it's possible to create a static object with a timer to refresh the data ?? if yes how can i do it please ??

Collectives™ on Stack Overflow

how to cache a query result in asp.net mvc application

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related