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: 195

Filed under:
|

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

Related posts about .NET

Related posts about datasets