Retry DataPortal_Fetch SQL Server mirroring (failover) configuration

Retry DataPortal_Fetch SQL Server mirroring (failover) configuration

Old forum URL: forums.lhotka.net/forums/t/10055.aspx


Joentje posted on Thursday, February 10, 2011

Hello,

We are thinking about mirroring our SQL Server. In that case a retry mechanism for our database commands (retry to the failover server) is needed, when an action on the primary database server fails.

Do we have to change our code of all DataPortal_Fetch methods, to try/catch/retry the database actions ourselves, or is there already built-in CSLA functionality to accomplish this?

Thank you very much in advance for your help!

Kind greetings,

Jeroen

RockfordLhotka replied on Thursday, February 10, 2011

There is nothing built into the data portal or Csla.Data to do this.

I would recommend implementing a formal data access layer that your DataPortal_XYZ methods can invoke. That DAL can then abstract concepts like retry so the invocation code in the DP_XYZ methods remain focused on interacting with the state of the business object.

Joentje replied on Thursday, February 10, 2011

Rocky,

Thank you very much for your quick and clear answer!

Kind greetings,

Jeroen

Copyright (c) Marimer LLC