Preloading Data outside of DataLoadOptions
-
Hello All, I have a module i'm working on that runs hundreds of individual rules over and over against a set of data. The issue i'm coming up against, is that although each linq query that loads each individual rules data only takes 30 or 40 milliseconds, once you multiply that by a few hundred, things start getting unrulely. I thought of using dataload options, but each rule has it's own detailed linq query on this set of data that excludes dataload options from benefiting me. What i'm really looking for is a way to load all of the data into a in-memory temp db, run my linq queries against that db, and then lastly push the data back when the rules have completed. I know that I can use a dataset and run queries against that, but I was curious if there was a slick way to do it with the datacontext outside of a dataset. Any suggestion would be greatly appreciated, Ryan