public override bool Delete(IList <SyncAction> actions)
{
SQLiteAccess db = new SQLiteAccess(Path.Combine(this.StoragePath, Configuration.DATABASE_NAME), false);
using (SqliteConnection con = db.NewSQLiteConnection())
{
if (con == null)
{
throw new DatabaseException(String.Format(m_ResourceManager.GetString("err_somethingNotFound"), Path.Combine(this.StoragePath, Configuration.DATABASE_NAME)));
}
string cmdText = "DELETE FROM " + Configuration.TBL_ACTION +
" WHERE " + Configuration.COL_ACTION_ID + " = @id";
SqliteParameterCollection paramList = new SqliteParameterCollection();
foreach (SyncAction action in actions)
{
paramList.Clear();
paramList.Add(new SqliteParameter("@id", DbType.Int32)
{
Value = action.ActionId
});
db.ExecuteNonQuery(cmdText, paramList);
}
}
return(true);
}
