public void DownloadRetailers()
        {
            var retailerResponse = api.getRetailers();
            using (CatalogDataContext dc = new CatalogDataContext())
            {
                foreach (Retailer retailer in retailerResponse.getRetailers())
                {
                    SS_Retailer ssRetailer = new SS_Retailer() { id = System.Guid.NewGuid(), name = retailer.getName(), retailer_id = (int)retailer.getId(), url = retailer.getUrl() };
                    dc.SS_Retailers.InsertOnSubmit(ssRetailer);
                }

                dc.SubmitChanges();
            }
        }
 partial void UpdateSS_Retailer(SS_Retailer instance);
 partial void DeleteSS_Retailer(SS_Retailer instance);
 partial void InsertSS_Retailer(SS_Retailer instance);