Search code examples
azure-devopssql-server-ce

SQL Server CE, type or namespace not found on Azure Devops

The type or namespace name 'SqlServerCe' does not exist in the namespace 'System.Data'

Builds locally, won't build on Azure Devops

This may be intentional? The app is deployed on a local corporate network and not meant for public consumption.

Again, builds locally and all references are correct and working otherwise.

Solution

  • You must install the SQL Compact runtime on the build server as part of your build, apparently it is not installed by default:

    For SQL Compact 3.5, use:

    msiexec /i %Build_SourcesDirectory%\tools\SSCERuntime_x86-ENU.msi /quiet /qn

msiexec /i %Build_SourcesDirectory%\tools\SSCERuntime_x64-ENU.msi /quiet /qn

    For SQL Compact 4.0, use:

     %Build_SourcesDirectory%\tools\SSCERuntime_x64-ENU.exe /quiet /qn