ASP vNext and PostgreSql

Question

exists currently any way, how to communicate with PostgreSql database, when I want to use ASP.NET vNext? I'm looking for solution, which will work mainly on linux.

EF7 supports only MS SQL a SqlLite now and Npgsql isn't ported for ASP.NET vNext.

Thanks

There was Redis and SqlLite implementation for beta1, if you want I maintain the Redis implementation. It will be soon ready for beta3. check out my gitub github.com/aguacongas/EntityFramework. Or you can implement your own PostgreSql implementation... — agua from mars
– agua from mars, Commented Mar 7, 2015 at 17:09
My EntityFramework.Redis is available on myget for beta3 add myget.org/F/chatle/api/v2 in your NuGet feeds — agua from mars
– agua from mars, Commented Mar 15, 2015 at 19:06

druss · Accepted Answer · 2015-05-05 17:52:32Z

3

Instead of EF7 you can use NHibernate together with Fluent NHibernate. Npgsql is also working well on ASP.NET 5 (vNext) on Linux. Here is a complete example of ASP.NET vNext application with NHibernate + PostgreSQL working on ubuntu server.

answered May 5, 2015 at 17:52

druss

1,88019 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

CrazyPyro · Accepted Answer · 2015-12-14 19:51:48Z

2

I'm still testing this out (on dnx-coreclr-win-x64.1.0.0-rc2-16177 at the moment), but they have made a lot of progress since @bricelam answered. They now have some EF7 docs including some on CoreCLR support

Here's part of my project.json:

"dependencies": {
  "EntityFramework.Commands": "7.0.0-rc2-*",
  "EntityFramework.Core": "7.0.0-rc2-*",
  "EntityFramework.Relational": "7.0.0-rc2-*",
  "EntityFramework7.Npgsql": "3.1.0-rc1-2",
},
"frameworks": {
  "dnxcore50": {}
}

~~You will probably need to add https://www.myget.org/F/npgsql-unstable/api/v3/index.json to your NuGet feeds in order to pull that package.~~ EDIT: I now specify an exact version of EntityFramework7.Npgsql": "3.1.0-rc1-2" and use only this feed in my NuGet.config: ~~https://www.myget.org/F/aspnetrelease/api/v3/index.json~~

EDIT: This is all now available in https://api.nuget.org/v3/index.json

In Startup.cs:

    public void ConfigureServices(IServiceCollection services)
    {
        services.AddEntityFramework()
            .AddNpgsql()
                .AddDbContext<YourDbContext>(options => options.UseNpgsql("your connectionString"))
            ;
    }

edited Dec 14, 2015 at 19:51

answered Nov 16, 2015 at 22:37

CrazyPyro

3,7273 gold badges34 silver badges39 bronze badges

2 Comments

ErikEJ Over a year ago

I dont think you need the MyGet source

CrazyPyro Over a year ago

Thanks @ErikEJ I tested this on dnx-coreclr-win-x64.1.0.0-rc2-16302 and edited my answer.

bricelam · Accepted Answer · 2015-03-09 16:36:25Z

0

The Npgsql community is working on an EF7 provider. I'm sure the code is available somewhere if you want to start using it.

answered Mar 9, 2015 at 16:36

bricelam

30.7k9 gold badges97 silver badges119 bronze badges

1 Comment

Rudis Over a year ago

Yes, thanks, but support for .NET Core is plan as a feature - github.com/npgsql/npgsql/issues/471

Collectives™ on Stack Overflow

ASP vNext and PostgreSql

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related