CODEWITHSUNDEEP
t-sqlado.netsql-server-2008-express
loviji
loviji

Reputation: 13080

how to try execute repeatly if command.ExecuteNonQuery() fails

how to try execute repeatly if command.ExecuteNonQuery() fails?

Upvotes: 0

Views: 542

Answers (2)

Konamiman
Konamiman

Reputation: 50273

The simplest way I can think is:

while(true) {
    try {
        command.ExecuteNonQuery();
        break;
    } catch(SqlException ex) { }
}

You should anyway put some extra control code in the catch block to prevent an infinite loop and/or to log the error.

Upvotes: 1

Serhat Ozgel
Serhat Ozgel

Reputation: 23766

You can try

bool executed = false;
while (!executed)
{
    try
    {
        command.ExecuteNonQuery();
        executed = true;
    }
    catch
    {
    }
}

You can add some more conditions like a timer or a counter but this does not seem to be a good idea. You should probably come up with a better recovery scenario.

Upvotes: 3

Related Questions