Accessing Datastore with multiple DO4 projects
0

I have multiple projects who are about to use DA04. Can I make them access the same database without LegacySkip enabled?. A database for each project seperatly isn't an option.

Greetings.

asked Oct 08 '10 at 05:44

Michiel%20Alders's gravatar image

Michiel Alders
50●6●7●10

edited Oct 08 '10 at 06:23

Alex%20Yakunin's gravatar image

Alex Yakunin
2971●4●4●12
One Answer:
oldest newest most voted
0

Yes, you can, but you must use different schemas to do this, since DO needs a set of tables in each of its domains in any case. These are:

  • Metadata.Type, Metadata.Assembly and Metadata.Extension tables
  • One table per each key generator type except GUID (Hi-Lo algorithm).

Previous versions of DO (v3.X) were allowing to specify table\view name prefix as well, so there was one more option. But currently we don't support it - schema name seems acceptable in most of cases.

If you describe your case more precisely, we'd think about other possible options.

answered Oct 08 '10 at 06:12

Alex%20Yakunin's gravatar image

Alex Yakunin
2971●4●4●12

Also note you can't mix objects from different Domains in queries and setup the relationships between them. All cross-domain relationships can be defined only in non-relational fashion (e.g. as key values), and DO won't be able to care about them (sync paired relationships, etc.).

On the other hand, we did a lot to allow you to build a large model inside a single Domain (e.g. 1000 types is absolutely ok) - IMO, that's the best option, if it can be used.

(Oct 08 '10 at 06:15) Alex Yakunin Alex%20Yakunin's gravatar image

Btw, I noted you tagged the question as "legacy-database" - what precisely this means? And why Legacy* modes don't suit here?

(Oct 08 '10 at 06:18) Alex Yakunin Alex%20Yakunin's gravatar image
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

about | faq | privacy | support | contact us

powered by OSQA