Blacker.MangaScraper.Library.DAL.StorageDAL.UpdateScrapers C# (CSharp) Метод

        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);
            }
        }