Scaling An Application With Many Shared Objects










0















I have a C# application (C#, WPF, Caliburn.Micro MVVM, Dapper) involving a Data Layer, Business Logic and Views.



As an example, a PK value (ClientGUID) from the Client table is used in many parts of the application and other tables. There is a function to Merge 2 Clients, which replaces all instances of the removed ClientGUID with the kept ClientGUID. In the UnitOfWork class, this is done by referencing all the tables and fields that need to be updated. This works fine.



As the application expands, and more tables and fields are added where a ClientGUID FK could be stored, how do we effectively remember to update all these functions, such as Merge, to include the new Tables/Fields?










share|improve this question
























  • Take a look at Software Engineering SE: How to keep a big and complex software product maintainable over the years?

    – Stijn
    Nov 13 '18 at 17:14











  • I appreciate that link. It's a heavy topic to address generally. I'm looking for a specific strategy to trigger or force developers to update some business logic layer when a new Table is introduced. Something more sophisticated than, "Where do we use ClientGUID in the Application?"

    – Lokked
    Nov 13 '18 at 21:32















0















I have a C# application (C#, WPF, Caliburn.Micro MVVM, Dapper) involving a Data Layer, Business Logic and Views.



As an example, a PK value (ClientGUID) from the Client table is used in many parts of the application and other tables. There is a function to Merge 2 Clients, which replaces all instances of the removed ClientGUID with the kept ClientGUID. In the UnitOfWork class, this is done by referencing all the tables and fields that need to be updated. This works fine.



As the application expands, and more tables and fields are added where a ClientGUID FK could be stored, how do we effectively remember to update all these functions, such as Merge, to include the new Tables/Fields?










share|improve this question
























  • Take a look at Software Engineering SE: How to keep a big and complex software product maintainable over the years?

    – Stijn
    Nov 13 '18 at 17:14











  • I appreciate that link. It's a heavy topic to address generally. I'm looking for a specific strategy to trigger or force developers to update some business logic layer when a new Table is introduced. Something more sophisticated than, "Where do we use ClientGUID in the Application?"

    – Lokked
    Nov 13 '18 at 21:32













0












0








0








I have a C# application (C#, WPF, Caliburn.Micro MVVM, Dapper) involving a Data Layer, Business Logic and Views.



As an example, a PK value (ClientGUID) from the Client table is used in many parts of the application and other tables. There is a function to Merge 2 Clients, which replaces all instances of the removed ClientGUID with the kept ClientGUID. In the UnitOfWork class, this is done by referencing all the tables and fields that need to be updated. This works fine.



As the application expands, and more tables and fields are added where a ClientGUID FK could be stored, how do we effectively remember to update all these functions, such as Merge, to include the new Tables/Fields?










share|improve this question
















I have a C# application (C#, WPF, Caliburn.Micro MVVM, Dapper) involving a Data Layer, Business Logic and Views.



As an example, a PK value (ClientGUID) from the Client table is used in many parts of the application and other tables. There is a function to Merge 2 Clients, which replaces all instances of the removed ClientGUID with the kept ClientGUID. In the UnitOfWork class, this is done by referencing all the tables and fields that need to be updated. This works fine.



As the application expands, and more tables and fields are added where a ClientGUID FK could be stored, how do we effectively remember to update all these functions, such as Merge, to include the new Tables/Fields?







c# database wpf mvvm repository






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 13 '18 at 17:22









stuartd

50.7k1098125




50.7k1098125










asked Nov 13 '18 at 17:11









LokkedLokked

326




326












  • Take a look at Software Engineering SE: How to keep a big and complex software product maintainable over the years?

    – Stijn
    Nov 13 '18 at 17:14











  • I appreciate that link. It's a heavy topic to address generally. I'm looking for a specific strategy to trigger or force developers to update some business logic layer when a new Table is introduced. Something more sophisticated than, "Where do we use ClientGUID in the Application?"

    – Lokked
    Nov 13 '18 at 21:32

















  • Take a look at Software Engineering SE: How to keep a big and complex software product maintainable over the years?

    – Stijn
    Nov 13 '18 at 17:14











  • I appreciate that link. It's a heavy topic to address generally. I'm looking for a specific strategy to trigger or force developers to update some business logic layer when a new Table is introduced. Something more sophisticated than, "Where do we use ClientGUID in the Application?"

    – Lokked
    Nov 13 '18 at 21:32
















Take a look at Software Engineering SE: How to keep a big and complex software product maintainable over the years?

– Stijn
Nov 13 '18 at 17:14





Take a look at Software Engineering SE: How to keep a big and complex software product maintainable over the years?

– Stijn
Nov 13 '18 at 17:14













I appreciate that link. It's a heavy topic to address generally. I'm looking for a specific strategy to trigger or force developers to update some business logic layer when a new Table is introduced. Something more sophisticated than, "Where do we use ClientGUID in the Application?"

– Lokked
Nov 13 '18 at 21:32





I appreciate that link. It's a heavy topic to address generally. I'm looking for a specific strategy to trigger or force developers to update some business logic layer when a new Table is introduced. Something more sophisticated than, "Where do we use ClientGUID in the Application?"

– Lokked
Nov 13 '18 at 21:32












0






active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53286269%2fscaling-an-application-with-many-shared-objects%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53286269%2fscaling-an-application-with-many-shared-objects%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Use pre created SQLite database for Android project in kotlin

Darth Vader #20

Ondo