What use as Database for developing asp.net vNext + Entity Framework 7 on OSX

asp.net-core entity-framework-core macos mono

Question

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

1
11
2/5/2015 4:01:24 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

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.

9
1/22/2015 7:21:21 PM

Popular Answer

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.

CampbellGolf

Related Questions

ASP.NET vnext and open database

For ASP.NET vNext you can choose to target the full .NET Framework or a slimmed down, bin-deployable, cross platform, Core framework. ...If you target the full .NET Framework then you get all the data access options you had before. If you target the CoreCLR then you can use the new version of Entity Framework (EF7). Currently we have the following ...
asp.net asp.net-core entity-framework-core
asked by Rowan Miller

ASP.NET vNext EF7 dbContext issues

IServiveProvider and IOptionAccessor are injected by the Dependency Injection the ASP.Net Core DI has limitation, you cannot have more than one constructor....Read this: ...http://blogs.msdn.com/b/webdev/archive/2014/06/17/dependency-injection-in-asp-net-vnext.aspx
asp.net-core asp.net-mvc c# entity-framework-core
asked by agua from mars

Dependancy Injected DbContext is empty after populating DbContext created with new (EF7, ASP.NET 5, vnext)

I might be wrong, but my assumption is that when you create a new instance of ...DbContext... in code, you are using the parameterless constructor that sets underlying connection string to some default value. However, DI-injected ...DbContext... could be resolved using another constructor with different connection string passed in explicitly....Tha...
asp.net asp.net-core dbcontext entity-framework entity-framework-core
asked by Sergey Kolodiy

ASP.NET 5 vNext EF7 SQLite TypeLoadException on CreateParameter

SQLite beta 1 is 8 months old and work was discontinued before migrations were supported in that build. Work on the SQLite provider has been restarted and by inspecting the tests it now looks like migrations are supported, but the only way for this to work in your application is to pull the source for EntityFramework from dev and build it locally. ...
asp.net-core c# entity-framework-core sqlite
asked by John Davidson

ASP.NET vNext with EntityFramework.Core

Ok I found the solution : I changed all my beta1 dependencies to beta2 and it worked. I have another problem yet : the website doesn't show the Home page, I have a simple blank page ......EDIT 2 : Sorry for the inconvenience, it seems that the dependency "Microsoft.VisualStudio.Web.BrowserLink.Loader" is still in beta1. It works now. Good luck ;)
asp.net-core entity-framework-core
asked by Christophe Gigax

Multiple dbContexts in ASP.NET vNext and EF7

Important Note:... The syntax for configuring the Entity Framework 7 services has changed since this post, which was accurate as of the last few beta rounds. The same idea should still apply to the new syntax though....Here is what I've been doing:...services.AddEntityFramework().AddSqlServer() .AddDbContext<DataContextA>(options =>...
asp.net asp.net-mvc c# entity-framework entity-framework-core
asked by CuddleBunny

ASP.NET vNext MVC and Entity Framework issues

Because EF7 is still in pre-release, you won't find any documentation on it in MSDN articles yet; you'll need to look at the ...EF7 GitHub Wiki... for any information....As you try out EF7 please bear in mind that this is a very early stage in the development of the new EF codebase and there are many features that are partially implemented or not y...
asp.net-core entity-framework entity-framework-core
asked by Matt DeKrey

Getting sqlite to work in ASP.NET 5 (vnext)

Wait for beta 6, that includes proper SQLite support and samples. Beta 6 comes tomorrow! (July 27)
.net-core asp.net asp.net-core-mvc entity-framework-core sqlite
asked by ErikEJ

Testing ASP.NET 5 with Entity Framework 7 using in memory database

If you're targeting .NET Core, you won't be able to make use of any automatic mocking frameworks....The best you can do is make all your methods in ...TestContext... virtual, then extend it in your unit tests....public class IntegrationTestContext : TestContext { // override methods here } ...You can then use...var context = new IntegrationTest...
asp.net-core entity-framework-core testing
asked by armen.shimoon

Run database migrations using Entity Framework ASP.NET Core on application start

Based on you comment above I would try this:...public void Configure(IApplicationBuilder app, IServiceProvider serviceProvider) { app.UseMvc(); this.Configuration = new ConfigurationBuilder() .SetBasePath(env.ContentRootPath) .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true) .AddJsonFile($"appse...
asp.net asp.net-core entity-framework entity-framework-core
asked by Stephen Wilson

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow