There is now some Visual Studio Code plugin that can connect to SQL Server, that could work as a temporary measure, but I agree having this in Visual Studio for Mac would be nice. As a cloud/mobile-first IDE, it should work with both full-ms-sql-server instances and Azure SQL instances.
I am using Visual Studio on Mac (release edition) and I want to connect to a SQL Server.
I am aware that probably the most recommended way would be to create a web service and I understand why.
However, I am so unsuccessful in doing it any other way. Surely a web backend is not the only way?
I can't seem to link to the Entity Framework and the System.Data.SqlClient does not work either.
Am I missing something crucial?I can set it up successfully in VSCode, but not when I want to create a Mac OS app.
In both cases, I am making an app that is 'mobile' on my computer.
Setting up SQLite is not a problem, but I am after sharing data between apps - is a web service, other than just being recommended actually the only way to do this within Xamarin?
jwknzjwknz1 Answer
You'll need to use the 'Core' version of the Entity Framework:
Visual Studio For Mac
See:https://docs.microsoft.com/en-us/ef/core/
tg2tg2