MSDeploy script

deploy-sqlproj

msbuild "MyApp.Database/MyApp.Database.sqlproj" `
  /t:"Build;Publish" `
  /p:SqlPublishProfilePath="MyApp.Database.automated-tests.publish.xml" `
  /p:UpdateDatabase=True `
  /p:PublishScriptFileName="publish-script.sql"

deploy.cmd

msdeploy ^
  -verb:sync ^
  -source:package="MyApp.Web\outdir\_PublishedWebsites\MyApp.Web.csproj_Package\MyApp.Web.csproj.zip" ^
  -dest:auto,computerName=https://myapp.scm.azurewebsites.net:443/msdeploy.axd?site=myapp,userName=$myapp,password=password,authtype=Basic,includeAcls=False ^
  -disableLink:AppPoolExtension ^
  -disableLink:ContentExtension ^
  -disableLink:CertificateExtension ^
  -setParam:name="IIS Web Application Name",value="myapp"

deploy.ps1

msdeploy `
    -verb:sync `
    -source:package=MyApp.Web\outdir\_PublishedWebsites\MyApp.Web.csproj_Package\MyApp.Web.csproj.zip `
    -dest:'auto,computerName="https://myapp.scm.azurewebsites.net:443/msdeploy.axd?site=myapp",userName="$myapp",password="password",authtype="Basic",includeAcls="False"' `
    -disableLink:AppPoolExtension `
    -disableLink:ContentExtension `
    -disableLink:CertificateExtension `
    -setParam:name=`"IIS Web Application Name`",value="myapp"

msbuild-web-app

Runner type: MSBuild
Build file path: MyApp.Web/MyApp.Web.csproj
MSBuild version: Microsoft Build Tools 2017

Command line parameters: 
/p:Configuration="Debug"
/p:OutDir="outdir"
/t:package

restore-nuget.cmd

".nuget/nuget.exe" restore MyApp.sln

run-tests.csproj

<Project
    ToolsVersion="15.0"
    xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

	<PropertyGroup>
		<Configuration Condition="'$(Configuration)'==''">Debug</Configuration>
	</PropertyGroup>

	<Target Name="Build">
		<Exec Command="msbuild.exe $(TestProject)\$(TestProject).csproj /verbosity:minimal" />
		<Exec Command="vstest.console.exe $(TestProject)\bin\$(Configuration)\$(TestProject).dll /Logger:trx;LogFileName=$(TestProject).trx" />
	</Target>
</Project>