I have a simple form, order header. It has a related table called order detail, I need to change a field value for all records in order detail for the current order when someone changes a value in the header. Best way to do this?



I have to do this because SQL Compact doesn't support multi table queries when using synchronization, so I have to set a flag on the detail records to base my query



My gut says to write a simple stored proc and call via 'ExecuteStoredProcedure', but I am asking because I think I might be overusing stored procs now that I understand them better, they are just so easy and lightweight.



Does ExecuteStoredProcedure respect CRUD/concurrency settings when called against a datasource? I also have two BO's on the form for the order header and detail records, is there a "execute this SQL statement against this BO" function I should be using instead of a stored proc?



Thanks.












Keith Chisarik