Npgsql connection string with Entity Framework core

Question

I'm using Npgsql with EF core to establish a connection to PostgreSQL for a demo console application. But I'm getting an exception 'Format of the initialization string does not conform to specification starting at index 0'. I think this because of some issue with the connectionstring. Any help is appreciated.

izengod · Accepted Answer · 2017-04-24 12:02:06Z

6

This should do fine:

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseNpgsql(@"Server=localhost;Port=5432;Database=dbname;User Id=Id;Password=password");
        base.OnConfiguring(optionsBuilder);
    }

answered Apr 24, 2017 at 12:02

izengod

1,1565 gold badges17 silver badges44 bronze badges

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

2 Comments

hrust Over a year ago

Is there a link to the documentation?

Sam Over a year ago

I keep having problems connecting. I'm keep getting Failed to connect to [::1]:5432. I tried to change to 127.0.0.1 and I am getting Failed to connect to 127.0.0.1:5432, but if I do psql -h 127.0.0.1 -p 5432 -U stellagunner -d MyTestDb it works fine.

Collectives™ on Stack Overflow

Npgsql connection string with Entity Framework core

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related