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

Posted on 2011-10-12
Last Modified: 2012-05-12
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 ?
Question by:GordonLiq
    LVL 16

    Expert Comment

    by:Easwaran Paramasivam

    Author Comment

    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?
    LVL 16

    Accepted Solution


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video discusses moving either the default database or any database to a new volume.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now