We found the following scenario:
central database (duplicated in multiple servers) clients Database 1 client database 2 There are user and roles among other things in the Central DB Client DBS has tables similar to each other, but left with some fields - contact, address, etc. ...
At present, each customer DB has his / her own user / land What is the information that is copied from central DB through a given process. I want to get the user / role information directly from Central DB (in reference to the effect of the User Unit in the brain table in client DB)
Is this possible? If not, what is a better way for central user configurations in many databases?
Does this mean that what is the contextual integrity between tables?
In the context of user survival in the Customer DB in the brain table
If yes, as long as you have the integrity between the reference tables in the same database It should be the best solution for your current solution.
If there is no way to go to the linked tables, then the tables will be considered local, but the data will be received every time from the central database.
You will not even prepare the EF4 linked tables.
Your other choice will be to go for a more service-oriented architecture to create a user service related to the web service. But maybe this is a lot of work.
Comments
Post a Comment