protected override IDataReader CreateReader()
        {
            var xmlReader = new XmlTextReader(new FileStream(LocalCacheLocation, FileMode.Open, FileAccess.Read, FileShare.Read, 3000, FileOptions.SequentialScan));
            var reader    = new ProductMappingFileReader();

            reader.Load(xmlReader);

            return(reader);
        }
        public override void Init(ConcentratorDataContext context)
        {
            base.Init(context);

            context.ExecuteStoreCommand(_productMappingCreate);
            File.Delete(LocalCacheLocation);
            DownloadFile(url, LocalCacheLocation);
            //BasicUnzip.Unzip(LocalCacheLocation + ".gz", LocalCacheLocation);

            using (var xmlReader = new XmlTextReader(new FileStream(LocalCacheLocation, FileMode.Open, FileAccess.Read, FileShare.Read, 3000, FileOptions.SequentialScan)))
            {
                var reader = new ProductMappingFileReader();
                reader.Load(xmlReader);
                BulkLoad(ProductMappingTableName, 100, reader);
            }
        }