Setup Entity Framework For Dynamic Connection String

by

The generated TemplateEntities class is marked as partial.

All you have to do is add another file with another part of the partial class definition that exposes the constructor you want to use:

partial class TemplateEntities
{
  public TemplateEntities( string nameOrConnectionString )
    : base( nameOrConnectionString )
  {
  }
}

Then pass your connection string in to this constructor.

You want to put this code in a different file so it doesn’t get over-written when you update your edmx model.

More Related Contents:

  1. Using Transactions or SaveChanges(false) and AcceptAllChanges()?
  2. Entity Framework change connection at runtime
  3. Entity Framework async operation takes ten times as long to complete
  4. Entity Framework Provider type could not be loaded?
  5. How to update record using Entity Framework 6?
  6. Entity Framework Refresh context? [closed]
  7. EntityType has no key defined error
  8. Serialization of Entity Framework objects with One to Many Relationship
  9. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  10. LEFT JOIN in LINQ to entities?
  11. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  12. Insert data using Entity Framework model
  13. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  14. How to compare only date components from DateTime in EF?
  15. Entity Framework 6 Code First Custom Functions
  16. Entity Framework Filter “Expression”
  17. How to get property change notifications with EF 4.x DbContext generator
  18. Entity Framework – stored procedure return value
  19. Order by dynamic parameter
  20. ef4 cause Circular reference in web service
  21. Linq Syntax – Selecting multiple columns
  22. Configure multiple database Entity Framework 6
  23. Self-referencing many-to-many recursive relationship code first Entity Framework
  24. Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute
  25. How to Identify the primary key duplication from a SQL Server 2008 error code?
  26. Entity Framework 4.1: Unable to cast from DbQuery to ObjectQuery
  27. Unable to find the requested .Net Framework Data Provider. It may not be installed
  28. Entity framework: StoreGeneratedPattern=”Computed” property
  29. Watch for a table new records in sql database
  30. LINQ Query to Convert string to datetime

Leave a Comment