asp.net - Multi-language website having two databases -

i working on multi language website. hosted in different 4 locations (countries), having dedicated database each. working fine. , project uses ef6.

the website has menu properties menuorder, visible etc. not want set these properties set each location individually. should set in dbkey database only.

is possible achieve each location uses 2 databases:

1. dbkeys : keys (common location)
2. dbresx : translations.

currently using single context. possible use 2 contexts same having foreign key relations in different context?

is possible use 2 contexts same having foreign key relations in different context?

yes possible use 2 contexts same application having foreign key relations in different context. there 2 situations this:

• two contexts of single databases

• two contexts of 2 different databases

i think talking second situation here, think want use unique primary keys used foreign keys because can not create relations in tables different databases , have form relations in application layer , use triggers , stored procedures in database consistency.

i answered question join accross different contexts here code example you:

public iqueryable<activityregister> getregisters(int activityid)  {     var activityregisters = activitydbcontext.activityregisters.where(x => x.activityid == activityid x.isactive == true).orderby(x => x.activityregisterid).tolist();     var roomidsfromactivityregisters = activityregisters.select(activityregister => activityregister.roomid);     var rooms = admindbcontext.rooms.where(room => roomsidfromactivityregisters.contains(room.id)).tolist();     var resultfromjoinacrosscontexts = (from activityregister in activityregisters                                          join room in rooms on activityregister.roomid equals room.id                                         select new activityregister                                         {                                             room = room,                                             roomid = room.id,                                             id = activityregister                                          });     return resultfromjoinacrosscontexts.asqueryable(); } 

as can see in code have perform join accross different contexts pull down data database memoery , perform join.

additional link:

one database or ten?