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.


asked Oct 08 '10 at 05:44

Michiel%20Alders's gravatar image

Michiel Alders

edited Oct 08 '10 at 06:23

Alex%20Yakunin's gravatar image

Alex Yakunin

One Answer:

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

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


Once you sign in you will be able to subscribe for any updates here



Asked: Oct 08 '10 at 05:44

Seen: 2,989 times

Last updated: Oct 08 '10 at 06:23

powered by OSQA