public static void EjecutarQuery(string querySQL, MySqlConnection connection)
{
try
{
MySqlCommand command = new MySqlCommand(querySQL, connection);
connection.Open();
IAsyncResult result = command.BeginExecuteNonQuery();
while (!result.IsCompleted)
{
Thread.Sleep(50);
}
command.EndExecuteNonQuery(result);
connection.Close();
}
catch (SqlException ex)
{
throw ex;
}
catch (InvalidOperationException ex)
{
throw ex;
}
catch (MySqlException ex)
{
//Se captura en el caso de intentar guardar un cliente que ya esta en
//la base de datos. Como no me interesa guardarlo, no hago nada.
if (ex.Message.IndexOf("PRIMARY", StringComparison.Ordinal) <= 0)
throw ex;
}
}