Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

How to clear the cache for Linq to sql with Stored Procedure

I am learning the Linq to Sql with stored procedure , it is very nice that I can call the SP like traditional function like (Linq.SPFunctionname())

the code I use like
DatabaseContext dbLinq=new DatabaseContext();

but everytime I call this , it return the same velue set . I cannot get the changed set that I have changed in code or by Sql directly.

how can I get the updated set ?
  • 2
1 Solution
Easwaran ParamasivamCommented:
GordonLiqAuthor Commented:
it is different concept,

useing all others are well.
Tables , Views are all well , can get the updated value after updated, only the SP.

and the things I cannot understand is :
why I still get the old even I create a new instance of LINQ?
Easwaran ParamasivamCommented:

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now