Making an Entity Framework Model span multiple databases

by

If you made a test and it worked you probably showed something nobody else know about. Till now I always answered this type of question: It is not possible to use single model with two databases (with some more ugly workaround based on views hiding tables from the second database). Now I know two workarounds.

The only disadvantage of this approach is that all changes made manually to SSDL part of your EDMX are always lost if you run Update model from database. This means either manual development of EDMX (which is quite hard work) or using some tool / script which will add your changes after each update from database.

More Related Contents:

  1. What are the best practices for using a GUID as a primary key, specifically regarding performance? [closed]
  2. How to run the same query on all the databases on an instance?
  3. Adding a query hint when calling Table-Valued Function
  4. Using NOLOCK Hint in EF4?
  5. How do I programmatically set the connection string for Entity-Framework Code-First?
  6. Why can’t Entity Framework see my Stored Procedure’s column information?
  7. summing values of a column based on id [closed]
  8. How do I use cascade delete with SQL Server?
  9. MSSQL Error ‘The underlying provider failed on Open’
  10. How to add Active Directory user group as login in SQL Server
  11. Maximum size of a varchar(max) variable
  12. How to update large table with millions of rows in SQL Server?
  13. How to Use UTF-8 Collation in SQL Server database?
  14. How do you specify a different port number in SQL Management Studio?
  15. Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
  16. Sequence as default value for a column
  17. Aggregate bitwise-OR in a subquery
  18. Parse XML in SQL Server
  19. Calling stored procedure using VBA
  20. How to find SQL Server running port?
  21. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  22. SQLServer IDENTITY Column with text
  23. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  24. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  25. Cannot bulk load. Operating system error code 5 (Access is denied.)
  26. INFORMATION_SCHEMA vs sysobjects
  27. Does query plan optimizer works well with joined/filtered table-valued functions?
  28. What are row, page and table locks? And when they are acquired?
  29. Bootstrapping SQL Express from WiX?
  30. Watch for a table new records in sql database

Leave a Comment