Entity Framework Encrypt Connection String

Question

I use Entity Framework and Linq to Entities. I want to encrypt the connection string and the EF has to decrypt automaticaly, How can I do it?

Thanks in advance,

Javier P. de Jorge

Is this a web app? ASP.NET has web.config encryption built in. — Craig Stuntz
– Craig Stuntz, Commented Aug 26, 2009 at 19:36
Yes, but how to do it or all is automatic even with the EF in the middle. — Javier P. de Jorge
– Javier P. de Jorge, Commented Aug 28, 2009 at 17:40
ASP.NET web.config encryption "just works." The EF won't care about it. — Craig Stuntz
– Craig Stuntz, Commented Aug 28, 2009 at 21:11

jlp · Accepted Answer · 2010-07-29 13:08:16Z

9

Use aspnet_regiis. In command line browse to (usually):

cd C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

and type:

aspnet_regiis -pef "sectionName of web.config" "path" - to encrypt
aspnet_regiis -pdf "sectionName of web.config" "path" - to decrypt

For example:

aspnet_regiis -pef "connectionStrings" "D:\projects\HelloWorldProject"

You don't need to do anything to make L2SQL read ecrypted connection string file.

answered Jul 29, 2010 at 12:50

jlp

10.4k16 gold badges57 silver badges76 bronze badges

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

1 Answer 1