title: Visual Studio 2017 Publishing error "Reference in the manifest does not match the identity of the downloaded assembly Microsoft.SqlServer.Types.dll."
body: <p>When i add this file from applications in Visual Studio It shows this error </p>
  
  <pre><code>ERROR DETAILS
  Following errors were detected during this operation.
  * [4/13/2019 8:39:17 PM] System.Deployment.Application.InvalidDeploymentException (RefDefValidation)
      - Reference in the manifest does not match the identity of the downloaded assembly Microsoft.SqlServer.Types.dll.
      - Source: System.Deployment
      - Stack trace:
          at System.Deployment.Application.DownloadManager.ProcessDownloadedFile(Object sender, DownloadEventArgs e)
          at System.Deployment.Application.FileDownloader.DownloadModifiedEventHandler.Invoke(Object sender, DownloadEventArgs e)
          at System.Deployment.Application.FileDownloader.OnModified()
          at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
          at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
          at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState, X509Certificate2 clientCertificate)
          at System.Deployment.Application.DownloadManager.DownloadDependencies(SubscriptionState subState, AssemblyManifest deployManifest, AssemblyManifest appManifest, Uri sourceUriBase, String targetDirectory, String group, IDownloadNotification notification, DownloadOptions options)
          at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory&amp; downloadTemp)
          at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState&amp; subState, ActivationDescription actDesc)
          at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String&amp; errorPageUrl, Uri&amp; deploymentUri)
          at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivationWithRetry(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String&amp; errorPageUrl)
  --- End of stack trace from previous location where exception was thrown ---
              at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
              at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivationWithRetry(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String&amp; errorPageUrl)
              at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
  </code></pre>
  
  <p>when i Add this file then it shows error even in Development PC when i try to <br/>install the click one <code>Exe</code> 
  <br/>
  and when i changed it to AUTO from application into Visual Studio it shows the following Error <br/>
  <a href="https://i.stack.imgur.com/2ePWW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2ePWW.png" alt="enter image description here"></a></p>
  
  <p>But On Development PC It does not show this error when i select Auto from 
  VS->Application Files only shows error on other(Client) PC
  I have also Tried 
  <a href="https://stackoverflow.com/questions/5337458/error-deploying-clickonce-application-reference-in-the-manifest-does-not-match">this</a>
  but not worked<br/>
  I have also changed the manifest Option but does not work</p>