Entity Framework Feature Suggestions

Mapping single model to multiple databases

Like to be able to build a domain model over data in multiple databases. With out having to manage database objects - linked servers, views etc.

1,537 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    NoelNoel shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Alessandro Dimasi Cobram IIAlessandro Dimasi Cobram II shared a merged idea: Change database membership for entity EF Code First  ·   · 
    Diego VegaAdminDiego Vega (Development Lead, DataFx) responded  · 

    Reverting status from “under review” to “no status” since we aren’t currently working on this. We will still consider it for future releases.

    31 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • DaveDave commented  ·   ·  Flag as inappropriate

        Now "No Status"? Why don't you add some developers to EF development and make it a first class framework? There are LOTS of missing pieces! Listen to your customers and then staff for the requests please!

      • Todd AspeotisTodd Aspeotis commented  ·   ·  Flag as inappropriate

        I don't deal with large applications all that often and I've just come across two where one has to read data from the other's. It doesn't make sense to put the two databases together, or to have some n-tier solution where web services are called and entities are cached etc. Direct access to the database gives us best performance and is reasonably maintainable.

        Right now we're using views and synonyms to surface parts of the first database into the second. It's not a huge burden, but less elegant than, say, EF understanding multiple database and being able to query across them.

      • Mojtaba KavianiMojtaba Kaviani commented  ·   ·  Flag as inappropriate

        This is important for large scale software developing. can shared data to one database and each other software have self databases.now in software can access shared and self data.

      • Michael SneadMichael Snead commented  ·   ·  Flag as inappropriate

        LINQ to SQL DBML's can do this by changing the schema of a given table.
        How is it that EF has NO WAY built in to do this? :( EF is the future - this needs to be fixed!

      • Nico SapNico Sap commented  ·   ·  Flag as inappropriate

        I'm changing the ConnectionString within EF and it just works.

        I use +/- 50 difference databases after the users login by overriding the connectionstring in DataContext.

        When using migrations, you can adjust the connectionstring (Update-Database ...), so this also works.

        This shouldn't be a primairy task, it isn't that hard to change it all.

      • HiteshHitesh commented  ·   ·  Flag as inappropriate

        This is very much required when the application supports multi-tenancy. And today, everybody wants to develop multi-tenant app....

      • AldoMegabrainAldoMegabrain commented  ·   ·  Flag as inappropriate

        This isn't a wish or a want... IT'S ESSENTIAL. @Ladislav: while I respect you, sometimes you can't see past the end of your nose... no fuss Cross database and Cross server querying is totally within the realm of the ORM - the whole point of it is to isolate you from the physical persistance store - for example, just look at what Azure does for servers (makes them disappear into a single entity is the answer in case you're struggling)

      • JonjoJonjo commented  ·   ·  Flag as inappropriate

        Why was this feature not added from the get go? I think this was a huge blunder. Because it added dozens of hours of coding in my team to achieve what EF cannot do right now. so our decision was to not use EF at all for this project and build our own EF to support multiple DBs. This is costing me money.

      • VaiVai commented  ·   ·  Flag as inappropriate

        This is extremly required for enterprise projects. We need to use multiple db on the single mssql server.
        Please add this feature as soon as possible you can.

      • AlAl commented  ·   ·  Flag as inappropriate

        This is required for enterprise project development. We are currently using multiple db's with MS SQL on single db server. We are also using synonym and merging edmx files.as a work-around. Please add this feature.

      • VinzVinz commented  ·   ·  Flag as inappropriate

        A direct mapping of synonyms is required. One of Entity Framework's claims is that it works best with Microsoft SQL Server, so this is expected. Although there are ways of merging edmx files together that's not a direct approach which we expect to have when using the Entity Framework

      ← Previous 1

      Feedback and Knowledge Base