Databases
StackOverflow2013
Postsdbo
POEntity Framework Code First with SQL Server Synonyms
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEntity Framework Code First with SQL Server Synonyms
    primarykey
    data
    text
    <p>I have the situation where I will have multiple companies accessing a single instance of my application, but I need to segregate their data to avoid accidentally loading data for another company, and to ease per-company database backups.</p> <p>Ideally, I'd like to split the data up into different databases as follows:</p> <ul> <li><p>One SQL Server database for a list of all the users, together with any tables that are <strong>common across all users / companies</strong></p></li> <li><p><strong>N number of company specific databases</strong>, each with the same schema but different data for each company. On logging in, I would dynamically select the database for the specific user's company</p></li> </ul> <p>I'd like to be able to query the company specific data tables, but perform joins onto the shared database (for example, so I could store a foreign key in the company database table, which joins onto the primary key of a shared table in the other database).</p> <p>I've discovered SQL Server Synonyms which look like they could do the job, and it seems I can successfully join between the two databases by using a query in SQL Server Management Studio.</p> <p><strong>Is it possible to use a Synonym table in Entity Framework Code First, and if so what would my POCO classes / DbContext need to look like?</strong></p> <p>Thanks :)</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USMatt Wilson
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POEntity Framework Code First with SQL Server Synonyms
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou won't be able to create a foreign key between databases, whether you are using a synonym or not, so I don't believe they could "do the job." See: http://stackoverflow.com/questions/1424327/foreign-keys-on-table-from-different-database If you don't need an explicit foreign key relationship, then can't you just join the local table to `centraldatabase.dbo.table` instead of creating synonyms to it all over the place? Or does EF not let you join across databases at all?
      singulars
      1. POEntity Framework Code First with SQL Server Synonyms
      1. USAaron Bertrand
    2. COI didn't realise you can join directly between two databases without a synonym - I've never had the need to before but that is useful. A fair point about not being able to use foreign keys, I guess this would never work - but even without an explicit relationship it still might be a way forward if I could get EF to support this. As far as I can tell, code first EF only supports a single database connection, and referencing a synonym as a table doesn't work.
      singulars
      1. POEntity Framework Code First with SQL Server Synonyms
      1. USMatt Wilson
    3. COFrom what I can tell, this is not the last EF/CF limitation you'll come across if your project does not fit into the strict parameters of that model. Is EF/CF something you have to use, or are you using it because it's "all the rage"? I suspect if you want to do anything moderately complex you'll quickly get frustrated with all of its boundaries and seek other alternatives.
      singulars
      1. POEntity Framework Code First with SQL Server Synonyms
      1. USAaron Bertrand
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload