Based on your documentation I am not sure if this will work or not since it is still a new query.
So let me put the questions another way.
if you want to load specific tables completely once when a program starts up, and then to use those tables for something like includes for many views without accessing the database again, how would you do it.
Examples are
Manufacturer Names, referenced by ManufacturerID
Distributor Names, referenced by DistributorID
State Names and Tax Rates referenced by StateID
etc...
Right now when the application starts, these viewmodels are all executed successfuly and if those views are used, there is no database access. But if that data is required for another view then the cache is ignored.
From a design perspective, it makes no sense to go to the database for data that has already been loaded in its entirety into cache. So what is the optimal devforce way to take advantage of this data, to reduce the need to retrieve this data over and over again from the database?
Also how would one write the query so that it retrieves only the desired fields from the database for the view in question? I undertstand there is a way with a lamda expression.