Using a summary view and the detail tables it draws on

[Ross Presser]

I have a StockInventoryTransactions table, that lists individual inventory transactions. I also have (in the database) a CurrentLevels view that summarizes them by StockID. I definitely want the summarizing to happen on the sql server, not in LINQ; when there are thousands of transactions, you only want to pull down one summary row.

The trouble is, if I add a new transaction to StockInventoryTransactions, and commit it, the CurrentLevels view does not reflect the change. ORM doesn't realize that this view depends on a table that has been just modified, and that any cached data is no longer valid.

Is there some way I can flag this view as volatile?

Backend database is MS Sql Server 2008 R2.  OpenAccess version is 2009.3.111, with reverse mapping.  Yes, this is old.  No, I would rather not take the time and risk to upgrade right now.

[Ady]

Hi Ross Presser,

 Have you enabled the 2nd Level Cache? You can specify that instances of the class mapped to the view are not cached by adding the following entry to the app.config

<namespace name="BusinessObjects">
    <class name="MappedToView">
        <extension key="cache-strategy" value="no" />
    </class>
</namespace>

You can find more information about the mapping entries, here and here. You can also manually evict the instances from the cache whenever you know the cached data is no longer valid by using the Database.Cache.EvictAll method.

Do get back in case you need further assistance.

Greetings,
Ady
the Telerik team

[Ross Presser]

No, I have not enabled 2nd level cache. This is about the primary cache. I will try using scope.Evict to get the data out of memory.