How to get connectionString from EF Core 2.0 DbContext

Question

In EF6 works this code:

 public string GetConnectionString(DbContext ctx) { ObjectContext _objectContext = ((IObjectContextAdapter)ctx).ObjectContext; if (_objectContext?.Connection != null) { EntityConnection entityConnection = _objectContext.Connection as EntityConnection; return entityConnection?.StoreConnection?.ConnectionString; } return null; }

How to do it in EF Core 2.0 ?

ErikEJ · Accepted Answer · 2021-09-15 13:59:09Z

145

var connectionString = ctx.Database.GetDbConnection().ConnectionString;

with EF Core 5:

 var connectionString = ctx.Database.GetConnectionString();

edited Sep 15, 2021 at 13:59

answered Jul 26, 2017 at 16:19

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

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

5 Comments

Cyrus Over a year ago

thanks, found it in nuget package: Microsoft.EntityFrameworkCore.Relational

Khodaie Over a year ago

But it doesn't include the password.

Christopher Over a year ago

@Khodaie, the password will be in there until a connection is opened, unless you use Persist Security Info = true in your connection string. You could fetch the connection string in your context's constructor and store it in a private field, that way you have access to it later on. However, that defeats some of the added security, so be careful.

mr_squall Over a year ago

In Ef Core 2.2 you need to add using Microsoft.EntityFrameworkCore;

Thomas Over a year ago

Without a using statement: Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.GetConnectionString(ctx.Database)

Collectives™ on Stack Overflow

How to get connectionString from EF Core 2.0 DbContext

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related