Does Compiled Query caching on the server ? RRS feed

  • Question

  • Hi
    i have question about Compiled Query.
    does compiled query caches on the client or server ?
    i want to know does compiled query is useful in multi User Environment ?
    this is my Signature
    Sunday, October 18, 2009 1:45 PM


  • It is cached in the app domain where your context resides on. If you have multi user environment and each of them has a winform application that uses EF, then each of them has it's own context and it's cache. If, on the other hand, all the users use an asp.net application, the context resides on the web server and therfore the cached query is in the web server
    Please mark posts as answers/helpful if it answers your question
    • Marked as answer by Yichun_Feng Friday, October 23, 2009 1:41 AM
    Sunday, October 18, 2009 5:17 PM