Entity Framework and Connection string with custom Encryption

Question

I am using an Oracle DB with EF 6 code first. And did custom encryption on connection string. Connection string stores in separate config file "connstring.config": There is a clear connection string without encryption

<?xml version="1.0" encoding="utf-8" ?>
<connectionStrings>
  <add name="MyConnString" connectionString="Data Source=MySource;User ID=UserID;Password=Password;PERSIST SECURITY INFO=True;"
  providerName="Oracle.ManagedDataAccess.Client" />
</connectionStrings>

Data sources in web.config file.

MyDbcontext:

public static string GetConnectionString()
{
    string encodedConnStr = ConfigurationManager.ConnectionStrings["MyConnString"].ConnectionString.ToString();
    string result = Crypto.Decrypt(encodedConnStr);
    return result;
}
public MyDbContext() : base(GetConnectionString()){}

And when I run application I am getting Server Error : Unable to complete operation. The supplied SqlConnection does not specify an initial catalog or AttachDBFileName.

How can I solve this?

Debug your app: is your connection string being decrypted correctly? Does the connectino string itself work? Do a web search on the error message. — Igor
– Igor, Commented Nov 19, 2016 at 10:01
Yes, decryption works correctly. I tried to type connections string directly in base, same thing — Drake
– Drake, Commented Nov 19, 2016 at 10:16
result returns correct connection string. Error appears when I call DbContext — Drake
– Drake, Commented Nov 19, 2016 at 10:57

Community · Accepted Answer · 2017-05-23 10:32:49Z

Because you are passing the connection string directly to the DbContext constructor you need to provide it with a database provider otherwise it does not know what database type it is creating connections for. The easiest thing to do is to alter the connection string, you can do this post encryption in your static method or in your encrypted connection string. Based on your connection above I believe oracle.manageddataaccess.client is the correct provider but test it and see.

Provider=oracle.manageddataaccess.client;Data Source=MySource;User ID=UserID;Password=Password;PERSIST SECURITY INFO=True

You can also try thing according to this other answer I found on SO: How to set manually an Oracle Connection String in a DbContext

class MyDbContext: DbContext
{
    public MyDbContext() : base(new OracleConnection(GetConnectionString()){}
    ...
}

If you are still experiencing problems update your question with just the relevant parts: that you cannot instantiate a DbContext instance when you manually provide a connection string. As it is written now it is very easy to make the assumption that your issue was with the encryption/decryption but these are irrelevant to the actual problem.

Drake · Accepted Answer · 2016-11-19 12:16:49Z

1

It was solved by setting defaultConnectionFactory to

Oracle.ManagedDataAccess.EntityFramework.OracleConnectionFactory, Oracle.ManagedDataAccess.EntityFramework

answered Nov 19, 2016 at 12:16

Drake

1652 silver badges12 bronze badges

Collectives™ on Stack Overflow

Entity Framework and Connection string with custom Encryption

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related