Managing Data Prefetching and Dependencies with .NET Typed Datasets
Posted
by Derek Morrison
on Stack Overflow
See other posts from Stack Overflow
or by Derek Morrison
Published on 2008-10-31T14:38:24Z
Indexed on
2010/04/29
14:17 UTC
Read the original article
Hit count: 231
I'm using .NET typed datasets on a project, and I often get into situations where I prefetch data from several tables into a dataset and then pass that dataset to several methods for processing. It seems cleaner to let each method decide exactly which data it needs and then load the data itself. However, several of the methods work with the same data, and I want the performance benefit of loading data in the beginning only once.
My problem is that I don't know of a good way or pattern to use for managing dependencies (I want to be sure I load all the data that I'm going to need for each class/method that will use the dataset). Currently, I just end up looking through the code for the various classes that will use the dataset to make sure I'm loading everything appropriately.
What are good approaches or patterns to use in this situation? Am I doing something fundamentally wrong? Although I'm using typed datasets, this seems like it would be a common situation where prefetching data is used.
Thanks!
© Stack Overflow or respective owner