could not load file or assembly 'System.Data.SqlClient'

[walterfranssen]

If i run the code (cake version 0.29):
cakeContext.ExecuteSqlQuery(sql.ToString(), new SqlQuerySettings{
Provider = "MsSql",
ConnectionString = connectionString
});

I get the following code:
Loaded 'C:\Program Files\dotnet\shared\Microsoft.NETCore.App\2.0.7\System.Data.Common.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
Resolving assembly System.Data.SqlClient, Version=4.2.0.2, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Exception while resolving assembly System.Data.SqlClient: Could not load file or assembly 'System.Data.SqlClient, Culture=neutral, PublicKeyToken=null'. The system cannot find the file specified.
Could not load file or assembly 'System.Data.SqlClient, Version=4.2.0.2, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified.