public void ExportVendors()
 {
     var query = this.mySqlContext.Vendors;
     foreach (var vendor in query)
     {
         SQLServer.Models.Vendor newVendor = new SQLServer.Models.Vendor()
         {
             VendorName = vendor.VendorName,
             Id = vendor.Id
         };
         this.sqlServerContext.Vendors.Add(newVendor);
     }
     this.sqlServerContext.SaveChanges();
 }
        public void ExportVendors()
        {
            var query = this.mySqlContext.Vendors;

            foreach (var vendor in query)
            {
                SQLServer.Models.Vendor newVendor = new SQLServer.Models.Vendor()
                {
                    VendorName = vendor.VendorName,
                    Id         = vendor.Id
                };
                this.sqlServerContext.Vendors.Add(newVendor);
            }
            this.sqlServerContext.SaveChanges();
        }