How can I use caching to improve performance?
<p>My scenario is : <code>WebApp  -&gt;  WCF Service  -&gt; EDMX  -&gt; Oracle DB</code></p>

<p>When I want to bind grid I fetch records from Oracle DB using EDMX i.e LINQ Query. But, this degrades performance as multiple layers take place between WebApp &amp; Oracle DB. Can I use caching mechanism to improve the performance? But as far as I know cache is shared across the whole application. So, if I update cache other user might receive wrong information. Can we use caching per user? Or is there any other way to improve performance of the application?</p>
