Using the SqlClient namespace I'm not able to connect to a sql server which uses encrypted transportation.
Setting the flag Encrypt to true in the connection string results in an NotImplementedException
"SSL encryption for data sent between client and server is not implemented."
For example this is needed to directly connect to an azure database which enforces the use of encryption.
The API documentation shows the right usage which nevertheless result in the exception.
There was a patch available 7 years ago which claims that it will fix this issue:
It would be great if this feature will be available in the future. The use of SqlClient requires the Xamarin business license and should implement encryption for sql connections.
I wanted to add another voice requesting this feature. This is, literally, the only feature that prevents me from using Mono on a Mac. The only two database servers I need to connect to both require encrypted connections (an on-premise server and an Azure server).
Ping. What is the status on this bug? Any progress or changes?
I'm also hitting this bug:
- On Windows + Visual studio, everything works fine
- On OSX + Xamarin Studio I'm getting an Exception:
(System.NotImplementedException: SSL encryption for data sent between client and server is not implemented.)
- On Xamarin Test Cloud I'm getting an even broader Exception:
I'm hitting this bug because we want to make a secure connection with an Azure SQL Database.
Really important issue, needs high priority.
+1 - With the new Visual Studio Mac Preview released, only thing stopping me from switching over to my Mac is this encryption bug. Any updates on possible fix to this?
There is this NuGet package available: https://www.nuget.org/packages/System.Data.SqlClient/
Which really is what you need, i'm not sure if it works under Mono, but it definitely should work under .NET Core. If you're not familiar with .NET Core then i suggest you take a look at that, it's cross platform and actively being developed.
Guys look, if Xamarin is going to continue to use Mono then this is a seriously critical feature to not have implemented. It prevents EF Core from connecting to ANY Azure databases.
Mono 5.10 has significantly improved System.Data implementation which should resolve this issue. If you can still reproduce it please reopen the issue.
Tested in 5.8 and 5.10
Works in 5.10 => Yeah!