Accessing Datastore with multiple DO4 projects

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 Alders
50●6●7●10

edited Oct 08 '10 at 06:23

Alex Yakunin
2971●4●4●12

One Answer:

oldest newest most voted

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 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

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

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

community wiki

Subscription:

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

Tags:

DataObjects.Net ×574
legacy-database ×6
multiple-schemes ×6
domain-model ×3

Asked: Oct 08 '10 at 05:44

Seen: 2,989 times

Last updated: Oct 08 '10 at 06:23

Subscription:

Related questions