How to in-code supply the password to a connection string in an ADO.Net Entity Data Model

by

When you create your context, you can set a connection string. To build this connection string, you can parse the connection string without the password with an EntityConnectionStringBuilder and then parse the inner connection string with an other ConnectionStringBuilder, depending on your browser. Then you can set the password and pass it to the constructor.

var originalConnectionString = ConfigurationManager.ConnectionStrings["your_connection_string"].ConnectionString;
var entityBuilder = new EntityConnectionStringBuilder(originalConnectionString);
var factory = DbProviderFactories.GetFactory(entityBuilder.Provider);
var providerBuilder = factory.CreateConnectionStringBuilder();

providerBuilder.ConnectionString = entityBuilder.ProviderConnectionString;

providerBuilder.Add("Password", "Password123");

entityBuilder.ProviderConnectionString = providerBuilder.ToString();

using (var context = new YourContext(entityBuilder.ToString()))
{
    // TODO
}

More Related Contents:

  1. How can I add user-supplied input to an SQL statement?
  2. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  3. There is already an open DataReader associated with this Command which must be closed first
  4. SQLite Database Locked exception
  5. c# Using Parameters.AddWithValue in SqlDataAdapter
  6. SqlConnection SqlCommand SqlDataReader IDisposable
  7. SqlBulkCopy from a List
  8. Exception when AddWithValue parameter is NULL
  9. The mapping of CLR type to EDM type is ambiguous with EF 6 & 5?
  10. Use of SqlParameter in SQL LIKE clause not working
  11. Insert into C# with SQLCommand
  12. WHERE IN (array of IDs)
  13. How to fill a datatable with List [duplicate]
  14. Exclude a field/property from the database with Entity Framework 4 & Code-First
  15. Thread safety for DataTable
  16. How to fill Dataset with multiple tables?
  17. Internal .NET Framework Data Provider error 1025
  18. Is DbContext the same as DataContext?
  19. Entity Framework Code Only error: the model backing the context has changed since the database was created
  20. How do I re-write a SQL query as a parameterized query?
  21. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  22. Check if a SQL table exists
  23. Unable to find the requested .Net Framework Data Provider – SQLite
  24. Change db table name in EF4 (entity framework 4)
  25. How do I create an expression tree for run time sorting?
  26. Fastest method for SQL Server inserts, updates, selects
  27. Entity Framework Code First naming conventions – back to plural table names?
  28. Why does the SqlParameter name/value constructor treat 0 as null?
  29. How do I connect to a SQL database from C#?
  30. How can I Pass a Table Name to SqlCommand?

Leave a Comment