Implementing database caching in ASP.NET
<p>I'm considering implementing sql database caching using the following scheme:</p>

<ol>
<li>In the ASP.NET webapplication I want a continuously running thread that check's a table, say dbStatus, to see if field dbDirty has been set true. If so, the local in-memory cache is updated, querying a view in which all needed tables are present.

<ol start="2">
<li>When any of the tables in the view is updated, a trigger on that table is fired setting dbStatus.dbDirty true. So this would mean I have to add a on insert,update,delete trigger on those tables</li>
</ol></li>
</ol>

<p>One of the reasons I want to implement such a caching scheme is that the same database is used in a Winform version of this application.</p>

<p>My question: is this a viable approach?</p>

<p>Many thanks in advance for helping me with this one, Paul</p>