How to create a DbContext instance of the specified database type

Question

I know that the default return here is the SQL Server database type, but I need the MySQL database type, the problem is to create a DbContext instance of the specified database type?

Of course, I know that it can also be created by specifying the connectionName, but the database connection string is encrypted and the string needs to be decrypted

The pseudo code is as follows:

public partial class MyDbContext : DbContext
{
    static string mysqlConn = ReadConnectionString(); //Get the encrypted MySQL connection string

    public MyDbContext() : base(mysqlConn)
    {
        // Even if I want to modify the connection string in this way, nor will it throw a connection string malformed exception
        Database.Connection.ConnectionString = DecryptConnectionString(mysqlConn);
    }
}

What framework and version do you use ? – Serg Shevchenko Dec 30 '18 at 14:21 — Serg Shevchenko, Dec 30 '18 at 14:21
.NET Framework 4.5 + EntityFramework 6 – win10shit Dec 30 '18 at 16:09 — win10shit, Dec 30 '18 at 16:09

score 0 · Answer 1 · answered Dec 30 '18 at 09:47

Ok, it's about what I expected, few of my questions can be answered.

Although I am not too familiar with EntityFramework, by looking at the source code of DbContext, I can almost certainly determine that this is a design flaw, it lacks a constructor like this:


Public DbContext(string connectionString, string providerName)

score 0 · Answer 2 · answered May 31 '20 at 12:32

0

I had same problem and found .Net framework 4.5 needs additional attribute on DbContext class to use MySql as below

[DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))]
public class MySqlContext : DbContext
{
...
}

answered May 31 '20 at 12:32

Kevin Youn

721
6
4

How to create a DbContext instance of the specified database type

2 Answers2