title: Compare list if it's in SQL table Column
body: <p>I have a console application that is scraping data from a website, this is the scraping part:</p>
  
  <pre><code>private static void getPageThumbLinks()
  {
      thumbUrlsList = new List&lt;string&gt;();
      HtmlWeb web = new HtmlWeb();
      web.UserAgent = "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";
      foreach (string value in pageLinks)
      {
  
          HtmlDocument doc = web.Load("http://www.example.com/" + value);
          foreach (HtmlNode nodes in doc.DocumentNode.SelectNodes("//td[@class='searchResultsSmallThumbnail']/a"))
          {
              HtmlAttribute href = nodes.Attributes["href"];
              var hreflink = href.Value;
              thumbUrlsList.Add(hreflink);
              //Console.WriteLine(hreflink);
          }
          compareToSql();
      }
  }
  </code></pre>
  
  <p>I have list with a collection of URLs, <code>thumbUrlsList</code> and an MSSQL Express table named <code>Table</code> with a Column named <code>link</code>.</p>
  
  <p>Is it possible to compare this list with the databases <code>link</code> column and check if it exists or not?</p>
  
  <p>If so if, can you give me an example?<br>
  It will be much appreciated. Thank you.</p>