The requirement for our project are as follows...BTw, this is my first winforms app, I am typically a graphic UI designer, so my lingo may be off here.

Winforms Application - MDI (esentially one parent form which just holds the navigation controls)

Multiple children Forms Open at once and if changes occur in one form then all other forms will update accordingly. Meaning if one form shares a related entity with another form and that entity is changed then the update cascades.

The important part is that it cannot repaint the UI.

I thought I would be able to use LINQ dataview from the dataset, but it does not handle joins in queries so that is out the window. Which would of be cool if it did support that and also change monitoring and propagate all those changes to the related queries that join to the changes entity.

Question,

Can I use LLBGEN object approach here? If so, I would I implement this? Keep in mind there are like 15 forms, and they can all be open at the same time (annoying yes). Thus if I delete a customer from the customers form, then all its properties get deleted on the address form.

Please try to explain this clearly. I am learning, and have been absorbing a lot of information, and as you guys know some of it is contradictory.

Thanks so much!

Open at once and if changes occur in one form then all other forms will update accordingly. Meaning if one form shares a related entity with another form and that entity is changed then the update cascades.

The important part is that it cannot repaint the UI.

I'm not sure I understand. I think you want to display the objects values on 15 forms, (some on one some on another, mayby some on every form) but when the values change you don't want to show the user?

Are the values being changed by the user or someone/thing else?

arschr wrote:

Open at once and if changes occur in one form then all other forms will update accordingly. Meaning if one form shares a related entity with another form and that entity is changed then the update cascades.

The important part is that it cannot repaint the UI.

I'm not sure I understand. I think you want to display the objects values on 15 forms, (some on one some on another, mayby some on every form) but when the values change you don't want to show the user?

Are the values being changed by the user or someone/thing else?

Here is a simple example

I have the following tables in my database

"ForecastTimeline"

ForecastTimelineID ForecastPeriodID ForecastDateTime

"PricingDrug"

PricingDrugID PricingDrugName

"PricingDrugGroup"

PricingDrugGroupID PricingDrugID CountryID

ForecastAdjustments

ForecastAdjusmentID PricingDrugGroupID ForecastTimelineID ForecastValue

In FORM #1 I display all PricingDrugs In FORM #2 I display all PricingDrugGroups IN FORM #3 I display all ForecastAdjusments

Now, If I delete PricingDrugs from form#2 I want the grid on form#2 and form#3 to update without repainting the UI. Show the new data (removing the deleted pricingdruggroups).

Now is this something I have to manually trigger, or is there a way (like in a relational database) I can setup my project that will handle this "cascade"

What do you mean by "Without repainting the UI" ? If you want items to be removed from grids then the UI will have to be repainted to display the changes - without a repaint the display will remain the same.

Matt