private int executeUpdate(SyncLogger logger, SyncRegionUpdate update)
{
logger.log(2, update.Statement);
SQLiteCommand cmd = new SQLiteCommand(connection);
cmd.CommandText = update.Statement;
if (update.Executions == null)
{
return cmd.ExecuteNonQuery();
}
else
{
int rowsAffected = 0;
foreach (ParameterSet set in update.Executions)
{
logger.log(3, string.Join(",", set));
cmd.Parameters.Clear();
foreach (string param in set)
{
SQLiteParameter p = new SQLiteParameter();
p.Value = param;
cmd.Parameters.Add(p);
}
rowsAffected += cmd.ExecuteNonQuery();
}
return rowsAffected;
}
}
private int executeUpdate(SyncLogger logger, SyncRegionUpdate update)
{
logger.log(2, update.Statement);
SQLiteCommand cmd = new SQLiteCommand(connection);
cmd.CommandText = update.Statement;
if (update.Executions == null)
{
return(cmd.ExecuteNonQuery());
}
else
{
int rowsAffected = 0;
foreach (ParameterSet set in update.Executions)
{
logger.log(3, string.Join(",", set));
cmd.Parameters.Clear();
foreach (string param in set)
{
SQLiteParameter p = new SQLiteParameter();
p.Value = param;
cmd.Parameters.Add(p);
}
rowsAffected += cmd.ExecuteNonQuery();
}
return(rowsAffected);
}
}
