public void UpdateScrapers(IEnumerable<IScraper> scrapers)
{
if (scrapers == null)
throw new ArgumentNullException("scrapers");
const string sql = @"INSERT OR IGNORE INTO Scrapers (ScraperId, Name) VALUES (@ScraperId, @Name)";
using (var connection = GetConnection())
using (var transaction = connection.BeginTransaction())
{
using (var command = GetTextCommand(sql))
{
foreach (IScraper scraper in scrapers)
{
command.Parameters.AddWithValue("@ScraperId", scraper.ScraperGuid);
command.Parameters.AddWithValue("@Name", scraper.Name);
ExecuteNonQuery(command, connection, transaction);
command.Parameters.Clear();
}
}
CommitTransaction(transaction);
}
}