Can I use SqlCredential with Entity Framework for the SQL connection?

Question

I would like to use the secure SqlCredential object to handle credentials for connecting to our SQL database.

.NET has an overload of the SqlConnection constructor that takes a connection string and SqlCredential so you don't have to embed the credentials in the connection string itself. I would like to use something similar for Entity Framework when creating a DBContext instance.

I need to control the connection string that gets used by Entity Framework for the connection.
I would like to use the more secure way of handling credentials, using either SQLCredential, NetworkCredential, or SecureString and passing that to the DBContext to create the connection.

Is there any way to do this?

(As an aside, we can't use Windows integrated security as our database is not set up for that and I am not in a position to change that.)

Perhaps this could be of help: Set credentials for Entity Framework in code, without using Integrated Security and only storing User ID in config file — NightOwl888
– NightOwl888, Commented Oct 6, 2017 at 19:27

Reno · Accepted Answer · 2017-10-06 20:18:44Z

4

You can create a regular SqlConnection with SqlCredential like you're used to and then pass this to the constructor of the entity framework DbContext.

The DbContext has this constructor:

public DbContext(DbConnection existingConnection, bool contextOwnsConnection);

edited Oct 6, 2017 at 20:18

answered Oct 6, 2017 at 20:01

Reno

5723 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Can I use SqlCredential with Entity Framework for the SQL connection?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related