.NET on Linux/Wine - notes

gistfile1.txt

apt update

export WINEARCH="win32"
apt install wine
apt-get install cabextract
dpkg --add-architecture i386 && apt-get update && apt-get install wine32
curl http://download.microsoft.com/download/D/D/3/DD35CC25-6E9C-484B-A746-C5BE0C923290/NDP47-KB3186497-x86-x64-AllOS-ENU.exe --output NDP47.exe

apt-get install wget unzip cabextract
curl https://raw.githubusercontent.com/Winetricks/winetricks/master/src/winetricks --output winetricks


https://appdb.winehq.org/objectManager.php?sClass=version&iId=25478



env WINEPREFIX=$HOME/winedotnet

===================================
apt update
apt install wine-stable
apt install wget unzip cabextract
wget https://raw.githubusercontent.com/Winetricks/winetricks/master/src/winetricks 
chmod +x winetricks

env WINEPREFIX=$HOME/winedotnet wineboot --init
env WINEPREFIX=$HOME/winedotnet ~/winetricks --unattended dotnet462

wget https://download.microsoft.com/download/E/E/D/EEDF18A8-4AED-4CE0-BEBE-70A83094FC5A/BuildTools_Full.exe
env WINEPREFIX=$HOME/winedotnet wine BuildTools_Full.exe /Passive


 NDP47.exe
/passive /norestart 

W_OPT_UNATTENDED

wget https://www.nuget.org/api/v2/package/Microsoft.Data.Tools.Msbuild/10.0.61804.210


curl -L https://www.nuget.org/api/v2/package/Microsoft.Data.Tools.Msbuild/10.0.61804.210 -o Microsoft.Data.Tools.Msbuild.nupkg


SSDTPath
SqlServerRedistPath

wget https://download.microsoft.com/download/E/E/D/EEDF18A8-4AED-4CE0-BEBE-70A83094FC5A/BuildTools_Full.exe
env WINEPREFIX=$HOME/winedotnet wine BuildTools_Full.exe /Q


SSDTPath=/src/Microsoft.Data.Tools.Msbuild.10.0.61804.210/lib/net46

env WINEPREFIX=$HOME/winedotnet wine "C:\Program Files\MSBuild\14.0\Bin\MSBuild.exe"

root@61a7dda3ffd5:/src/sql-server-samples/samples/applications/iot-smart-grid/Db
# SSDTPath=/src/Microsoft.Data.Tools.Msbuild.10.0.61804.210/lib/net46
root@61a7dda3ffd5:/src/sql-server-samples/samples/applications/iot-smart-grid/Db
# env WINEPREFIX=$HOME/winedotnet wine "C:\Program Files\MSBuild\14.0\Bin\MSBuild.exe" Db.sqlproj /p:SSDTPath=$SSDTPath /p:SqlServerRedistPath=$SSDTPath /p:SQLDBExtensionsRefPath=$SSDTPath /p:CmdLineInMemoryStorage=true /p:SqlPublishProfilePath=myprofile.xml /t:Build\;Publish

WINEDLLOVERRIDES="esent=n,b"


================================
<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
	<PropertyGroup>
		<IncludeCompositeObjects>True</IncludeCompositeObjects>
		<TargetDatabaseName>Test</TargetDatabaseName>
		<DeployScriptFileName>Test_Full.sql</DeployScriptFileName>
		<TargetConnectionString />
		<ProfileVersionNumber>1</ProfileVersionNumber>
	</PropertyGroup>
</Project>
================================
https://devblogs.microsoft.com/ssdt/sql-server-database-projects-and-team-foundation-build/
https://github.com/joelbrinkley/docker-ssdt/blob/master/Dockerfile
https://github.com/scottyhardy/docker-wine/blob/master/Dockerfile
================================
SqlPackage.exe /a:script /SourceFile:C:\temp\mydb.dacpac /TargetConnectionString:"Data Source=myserver;Initial Catalog=mydb;Integrated Security=true" /OutputPath:C:\temp


env WINEPREFIX=$HOME/winedotnet wine /src/Microsoft.Data.Tools.Msbuild.10.0.61804.210/lib/net46/sqlpackage.exe /Action:script /SourceFile:bin/Debug/Db.dacpac /DeployScriptPath=Storage /OutputPath:blah.sql /tsn:myhost /tdn:iot-db