Entity Framework Core 1.0 PostgreSQL API

Question

I'm trying to EF Core 1.0 with PostgreSQL with ASP.NET Core project, Here is my context class:

public class ApplicationDbContext : DbContext
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
        :base(options)
    {

    }

    public DbSet<Person> People { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        base.OnConfiguring(optionsBuilder);
    }
}

I'm added the following packages:

"dependencies": {
"Microsoft.NETCore.App": {
  "type": "platform",
  "version": "1.0.0"
},
"Microsoft.EntityFrameworkCore": "1.0.0",
"Npgsql.EntityFrameworkCore.PostgreSQL": "1.0.0",
"Microsoft.EntityFrameworkCore.Design": "1.0.0-preview2-final"
},

I've registered in Startup.cs as:

public void ConfigureServices(IServiceCollection services)
    {
        services.AddEntityFrameworkNpgsql()
                .AddDbContext<ApplicationDbContext>(options => options.UseNpgsql("User ID=postgres;Password=;Server=localhost;Port=1234;Database=ApplicationDbContext;Pooling=true;"));

        services.AddMvc();
    }

Now when I try to add a migration as dotnet ef migrations add InitialMigrations, I get a successful migration message. But when I connect to the server in pgAdmin, I do not see any newly created database whats wrong, where I'm going things wrong?

Please also provide a link of 1-1 for using PostgreSQL with EFCore if you have any.

No it does not worked at all, I'm trying this in Console App not in ASP.NET for learning. — Janshair Khan
– Janshair Khan, Commented Jul 13, 2016 at 7:14
@GeorgeChond I've updated the question for ASP.NET Core, can you please review it. — Janshair Khan
– Janshair Khan, Commented Jul 13, 2016 at 16:26

Shay Rojansky · Accepted Answer · 2016-07-14 13:47:25Z

1

Creating a migration doesn't create a database or update it - it just creates the migration code in your project which is capable of bringing the database up to date. You may be looking for dotnet ef database update.

Read the EFCore getting started docs carefully.

answered Jul 14, 2016 at 13:47

Shay Rojansky

16.9k3 gold badges44 silver badges73 bronze badges

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

2 Comments

Janshair Khan Over a year ago

O I just forgot the basic. Thanks for reminding me back. Actually I'm still confronting a problem when I update the database and try to open it in pgAdmin, I get an error saying invalid frontend message type 15, server terminated abnormally Can you figure out the cause?

Shay Rojansky Over a year ago

@JanshairKhan, I'd need more details for both problems in order to do anything. You should open issues for both.

Collectives™ on Stack Overflow

Entity Framework Core 1.0 PostgreSQL API

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related