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