Cyrus
Cyrus

Reputation: 2429

How to get connectionString from EF Core 2.0 DbContext

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 ?

Upvotes: 60

Views: 33139

Answers (1)

ErikEJ
ErikEJ

Reputation: 41749

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

with EF Core 5:

   var connectionString = ctx.Database.GetConnectionString();

Upvotes: 141

Related Questions