3

Unfortunately, due to issues with Azure's lack of EF 5 spatial support, I need to include the relevant DLL myself: related link

Once I included the SqlServerSpatial.dll I was able to complete successfully deploy by using the Publish tool inside of Visual Studio.

However, when I try to use the Github -> Azure deployment with the relevant DLLs being available in the github repro, the deployment fails with the message:

The process cannot access the file 'C:\DWASFiles\Sites\<my app name>\VirtualDirectory0
\site\wwwroot\bin\SqlServerSpatial.dll' because it is being used by another process.

I'm not really sure how to troubleshoot from here and could use some help. Thanks!

Eric98118
  • 397
  • 3
  • 15
  • What happens if you restart the website from the dashboard before deploying? Does that unlock the file? – levelnis Mar 02 '13 at 19:47
  • I'm getting the same error in the following directory: C:\DWASFiles\Sites\\VirtualDirectory0\site\wwwroot\App_Data\Dependencies\ – EdmundYeung99 Mar 03 '13 at 00:55
  • Hrmm, if I restart from the dashboard and then retry the failed deploy - that gets me past the failure. Not sure yet how to skip the failure completely. – Eric98118 Mar 04 '13 at 16:30
  • This question shouldn't be a problem anymore. – Eric98118 Jan 28 '15 at 23:07

1 Answers1

0

use nuget package manager instead of adding the dll and pushing dlls using git.

PM> Install-Package Microsoft.SqlServer.Types

Ignore the bin folder from git by adding bin/ in .gitignore file

usually adding dlls in source control causing issues and its not a good behavior.

Ammaroff
  • 944
  • 7
  • 22
  • Yeah, that wasn't possible when this question was written. There was a bug that has since been fixed, so I don't think the question is valid anymore. – Eric98118 Jan 28 '15 at 23:07