ASP.NET EntityFramework get database name

Question

I created an ASP.NET EF application with MySQL using the following tutorial: http://www.asp.net/identity/overview/getting-started/aspnet-identity-using-mysql-storage-with-an-entityframework-mysql-provider Its working but I don't like to set the name of my database hardcoded in the MySqlInitializer class - called myDatabaseName in the following snippet:

var migrationHistoryTableExists = ((IObjectContextAdapter)context).ObjectContext.ExecuteStoreQuery<int>(
        string.Format(
          "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '{0}' AND table_name = '__MigrationHistory'",
          "myDatabaseName"));

I'm looking for a way to get the name of the database from the DbContext dynamically so that I store the database-name only in the connection-string and not a second time in my MySqlInitializer. But I can't find any attribute for the name, neither in the DbContext nor in the Database-attribute of the DbContext.

johnny 5 · Accepted Answer · 2018-07-12 16:32:50Z

103

For those of you who are using EF core can do this as an alternative:

var databaseName = context.Database.GetDbConnection().Database

edited Jul 12, 2018 at 16:32

answered Mar 7, 2017 at 1:05

johnny 5

21.2k55 gold badges138 silver badges217 bronze badges

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

6 Comments

DMX David Cardinal Over a year ago

This is not up to date with EF Core 5.0

johnny 5 Over a year ago

@DMXDavidCardinal What has changed in EF Core 5.0?

DMX David Cardinal Over a year ago

I never used the previous versions so I can't really compare effectively, but the DbContext.Database property is of type DatabaseFacade which does not contain the method GetDbConnection(). The SQL Connection is now defined in a protected OnConfiguring method using a DbContextOptionsBuilder. However, this optionsBuilder doesnt not seem to be accessible outside the DbContext class.

johnny 5 Over a year ago

@DMXDavidCardinal It doesn't include the method because it's an extension method. See the MSDN Documentation

ADM-IT Over a year ago

make sure you have using Microsoft.EntityFrameworkCore;, otherwise you won't have GetDbConnection() method available.

|

pkmiec · Accepted Answer · 2023-03-03 08:52:59Z

64

This should do the job for you (works up to .NET 6)

string databaseName = context.Database.Connection.Database;

edited Mar 3, 2023 at 8:52

answered Jul 19, 2015 at 20:47

pkmiec

2,69421 silver badges16 bronze badges

1 Comment

Marcel Melzig Over a year ago

Does not work with .NET 7.0 anymore.

Collectives™ on Stack Overflow

ASP.NET EntityFramework get database name

2 Answers 2

6 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related