Second problem with SDTK. Filters. If you are using 2 BO that are bound with a SDTK and you filter one of them the second is filtered. Is there a reason for this? For my thought process is for lookups that rarely get update or automatically notified if DB changes then having a BO with a SDTK would work well and does. Up until one of those BO's are filtered for some reason and then All of the BO's are filtered. This obviously messes up a bunch of things.
Any ideas?
Richard
I'm full aware of the use of filters and when to use. All of my applications are in the millions of records and thousands of transactions an hour. For large datasets and heavy transacted tables it would be almost always be primary key usage only.
I'm using the filters on Dual Lookup Tables and Settings that are mostly static. For an example I have Shipper BO and the children ShipperMethods and ShipperWarehouse. So when you select a Shipper you filter the results of the ShipperMethods. This is done for drop down display as well as settings. These three BO's are used throughout the Shipping Module and contain less the 100 rows total on average. Preferably I simply just wanted to load them once for the entire application instead of loading and reloading all the time. In this type of instance I want to share the data but not the view. I guess I can build a caching system that simply copies data from BO to BO or look into the source and see what it takes to add a IsFilterEnabled Property.
I agree with your methodology, but like you mentioned towards the end of your last post, I would probably create a static or shared class that does this for me and then allows me to pass over a BO for population. You can definitely use the shared data table in this scenario as well.