Read DbContextOptions value in Entity Framework core constructor

Question

In my asp.net core service, I have this in the startup

services.AddDbContext<Mydb_Context>(
    options => options.UseSqlServer(Configuration["Settings:ConnString"]));

and to make it works, I created also this snippet:

public Mydb_Context(DbContextOptions<Mydb_Context> options) : base(options)
{
    //other stuff here
}

My problem now is: in "other stuff here" section, how can I read the options value and retrieve my connection string? Since there another dll and not the same project, I can't just read it again from the appsettings.json.

If I break my code during a debug session, I can see the connection string in the value inside this object, but I don't know how to get it properly. I see this value inside the "Extension" attribute of the options object.

So, how can I read the DbContextOptions value?

Ian Kemp - SO dead by AI greed · Accepted Answer · 2023-06-27 11:26:47Z

4

So, how can I read the DbContextOptions value?

You can (not publicly but using some EF Core internal infrastructure objects, in particular RelationalOptionsExtension class), but you don't need to.

To get the connection information, simply use context Database property and GetDbConnection method:

public Mydb_Context(DbContextOptions<Mydb_Context> options) : base(options)
{
    //other stuff here
    var connectionString = this.Database.GetDbConnection().ConnectionString;
}

edited Jun 27, 2023 at 11:26

Ian Kemp - SO dead by AI greed

1

answered Feb 15, 2018 at 13:23

Ivan Stoev

208k17 gold badges356 silver badges376 bronze badges

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

Collectives™ on Stack Overflow

Read DbContextOptions value in Entity Framework core constructor

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related