LLBLGen Runtime LLBlGen 3.5 .Network framework 4.0 C# Windows application SQL Server 2005

Is there a way to update all child tables when a parent table is updated witha value with LLBLGen?

Not sure I understand your question. Could you please explain in more details, or maybe post the SQL you want to execute.

Walaa wrote:

Not sure I understand your question. Could you please explain in more details, or maybe post the SQL you want to execute.

Example: I have table country with PK as CountryID and another column called Flag. It has child table State and City with CountryID as FK and colums called Flag.

Now when I update country table with flag=1 related child tables with corresponding FK [countryid] to be updated with flag=1

And how would you do it in SQL? I suppose you would execute to UPDATE statements one for each table.

With LLBLGen if you don't have these entities loaded already, you can use adapter.UpdateEntitiesDirectly() with the appropriate filter.

Walaa wrote:

And how would you do it in SQL? I suppose you would execute to UPDATE statements one for each table.

With LLBLGen if you don't have these entities loaded already, you can use adapter.UpdateEntitiesDirectly() with the appropriate filter.

OK