I'm trying to set up my environment for developing asp.net vNext + Entity Framework 7 on my OSX.
Apparently, there is no provider for MySQL neither PostgreSQL yet. Thus, what can be used as database for developing on OSX?
What you folks have been doing for develop asp.net vNext on OSX? Or should I set up a Windows VM?
Any suggestion?
I've got even an open issue on Github on this topic.
Cheers
We will have a PostgreSQL and/or MySQL provider for EF7 (either delivered by our team or we'll work with a provider writer to help them build it). Work hasn't started on them yet though.
We haven't been focusing on EF7 on Mono at this stage, so there are likely some rough edges. We do have some folks who have successfully used it to connect to a remote SQL Server though.
To date, no RDBMS is supported on OSX for EF7
.
Since (LocalDB)\v11.0
doesn't allow remote access and run on OSX/LNX, I've setup a SQLServer2012 Express
and SQLServer 2012 Standard Edition
hosted on a local Windows VM to establish a remote DB connection from my Visual Studio Code project.
From Visual Studio Code
running on OSX, EF7
fails to successfully connect and interact with those local SQL Servers. In this instance, I was using the ASP.NET 5
Music Store example project: GitHub Source
Oh, and with all the SSL requirements, AZURE SQL Server
is out of the question as an option.
Microsoft is heading in the right direction, we'll get there, but you're dealing with bleeding edge EF7
at the moment which is a complete reengineering from EF6
.