Encrypt password in App.config

by

Lets say this is your connection string:

<connectionStrings>
    <add name="cs" connectionString="Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=XXSDFASFDKSFJDKLJFDWERIODFSDFHSDJHKJNFJKSD;"/>
</connectionStrings>

Then you can do something like this:

string myCs = System.Configuration.ConfigurationManager.ConnectionStrings["cs"].ConnectionString;

System.Data.SqlClient.SqlConnectionStringBuilder csb = new System.Data.SqlClient.SqlConnectionStringBuilder(myCs);
csb.Password = EncDecHelper.Decrypt(csb.Password);
myCs = csb.ToString();

You can write EncDecHelper.Decrypt by using samples from here: Encrypt and decrypt a string

More Related Contents:

  1. MetadataException: Unable to load the specified metadata resource
  2. Entity Framework with NOLOCK
  3. DbArithmeticExpression arguments must have a numeric common type
  4. ADO.Net Entity Framework An entity object cannot be referenced by multiple instances of IEntityChangeTracker
  5. Entity Framework change connection at runtime
  6. Entity Framework Refresh context? [closed]
  7. EntityType has no key defined error
  8. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  9. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  10. Insert data using Entity Framework model
  11. ado.net Closing Connection when using “using” statement
  12. Using DataAnnotations with Entity Framework
  13. Entity Framework – retrieve ID before ‘SaveChanges’ inside a transaction
  14. Entity Framework with XML Files [closed]
  15. Mapping Database Views to EF 5.0 Code First w/Migrations
  16. The operation cannot be completed because the DbContext has been disposed error
  17. How to keep single SQL Server connection instance open for multiple request in C#?
  18. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  19. Fill an array (or arraylist) from SqlDataReader
  20. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  21. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  22. Autonumber with Entity Framework
  23. Unable to find the requested .Net Framework Data Provider. It may not be installed
  24. Entity framework: StoreGeneratedPattern=”Computed” property
  25. The ObjectContext instance has been disposed and can no longer be used for operations that require a connection [duplicate]
  26. How to create custom additional fields in UserProfile in MVC4
  27. Entity Framework Code First naming conventions – back to plural table names?
  28. Should the order of LINQ query clauses affect Entity Framework performance?
  29. How can set a default value constraint with Entity Framework 6 Code First?
  30. Why Entity Framework performs faster than Dapper in direct select statement [closed]

Leave a Comment