This question is locked. New answers and comments are not allowed.
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.
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.