Configure multiple database Entity Framework 6

by

It’s not important that how many DbContexts you have(In entity framework 6).
Just put connection strings in appConfig or webConfig of startup project.

Then you’re ready to go.

Example of appConfig with two connectionString with Ef 6.01 & Sql Compact 4.0

<configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <connectionStrings>
    <add name="MainDb" connectionString="Data Source=|DataDirectory|\Db.sdf" providerName="System.Data.SqlServerCe.4.0" />
    <add name="AnotherDb" connectionString="Data Source=|DataDirectory|\AnotherDb.sdf" providerName="System.Data.SqlServerCe.4.0" />
  </connectionStrings>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="System.Data.SqlServerCe.4.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlServerCe.4.0" type="System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact" />
    </providers>
  </entityFramework>

And example of DbContexts:

public class AppDb : DbContext
{
    public AppDb()
        : base("MainDb")
    {

    }
}

public class AnotherDb : DbContext
{
    public AnotherDb()
        : base("AnotherDb")
    {

    }
}

It’s not important that your contexts are in separated projects or not, only Config of startup project is important.

Let me know if any other information you need.

Good luck

More Related Contents:

  1. The entity type is not part of the model for the current context
  2. Entity Framework Provider type could not be loaded?
  3. How to update record using Entity Framework 6?
  4. How to filter “Include” entities in entity framework?
  5. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  6. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  7. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  8. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  9. Mapping composite keys using EF code first
  10. Setting unique Constraint with fluent API?
  11. Lazy Loading vs Eager Loading
  12. Entity Framework 6: audit/track changes
  13. Entity Framework 6 Code First Custom Functions
  14. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  15. Problems using Entity Framework 6 and SQLite
  16. The operation cannot be completed because the DbContext has been disposed using MVC 4
  17. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  18. Save detached entity in Entity Framework 6
  19. Eager , Lazy and explicit loading in EF6
  20. Entity Framework 6 transaction rollback
  21. DbContext discard changes without disposing
  22. How are people unit testing with Entity Framework 6, should you bother?
  23. Can you get the DbContext from a DbSet?
  24. How to Refresh DbContext
  25. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  26. How to group by DateTime.Date in EntityFramework
  27. NSubstitute DbSet / IQueryable
  28. How to use String property as primary key in Entity Framework
  29. How does the SQLite Entity Framework 6 provider handle Guids?
  30. How can set a default value constraint with Entity Framework 6 Code First?

Leave a Comment