Add SQL Server integration
This suggestion is migrated to Developer Community. Please use below link to view the current status.
Add SQL Server integration so that it's easier to build end to end mobile and web apps that contain Web API Core and Entity Framework Core.
Would be a highly appreciated feature
Please add it!
Richard Lalancette commented
Adding my vote to this.
I went back to windows 10 when I saw I couldn't not fire up a SQL database just like with my previous project on windows 10.
I late saw how to build this through Docker, but it was rather insane process.
Hopefully Micro-so-soft will not take 10 years to add such a simple feature.
Yeah! Good idea
Please, add it
Raza Balbale commented
This will definitely help.
Syed Shaikh Syed Ahmad commented
This might help
SQL Operations Studio
mssql-server-linux works with Visual Studio Code but how to make this work with Visual Studio Community for Mac?
Travis Wright commented
@Gizzer - you can use the mssql-server-linux container on Docker for Mac to get a nice lightweight local DB. Once SQL Server 2017 GA is available you can choose between Developer or Express Edition for local development.
Going the whole hog and actually having SQL Server Express for Mac would be even better!
Miha Valencic commented
Please add support for adding Tools packages like `Microsoft.EntityFrameworkCore.Tools.DotNet`. Currently the VS reports an error and you need to add tools manually to the csproj file.
Package 'Microsoft.EntityFrameworkCore.Tools.DotNet 1.0.0' has a package type 'DotnetCliTool' that is not supported by project 'MacMvc'.
It will also helpfull in debuging database connection
Hawk leaf commented
I agree with Warren here, I'm hoping to use visual studio on Mac as a full environment for developing ASP.NET Core applications. So as one of the main parts of a MVC framework, adding a database in this way would be very beneficial.
This could also be solved by providing a temporary set of documentation pages on how to get around this problem.
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.