I asked kind of the same question on SQL Server forum, specifically using VFP as the language of choice. But I was wondering also how .NET developers address this design. How do you do the following update of SQL Server tables?
Say you have 3 or 4 tables that a process need to update. For some tables only one record is to be updated. For others, several records. For some tables, the records/rows that are to be updates are not known until records of another table are processed. So it is kind of sort of a complicated business logic. But at the end, some tables and rows have to be updated.
Do you use Stored Procedures for that? If you would not want to use Stored Procedures (which is what I would prefer), how do you conceptually address this problem?
Thank you in advance for sharing.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham