Page 1 of 1

CreateDatabase does not work with ForeignKeys

Posted: Fri 04 Mar 2022 14:32
by FlorianDahn
Hey!
I tried to build a database installer and used the CreateDatabase method of the DataContext.

But im receiving an error that a ForeignKey can not be installed due to missing table.
So it seems it tries to install tables and keys at the same time, which is not got as it looks like.

Would it be possible to install the tables first and then the keys ?

When using IgnoreErrors=true it install all tables which does not have a foreign key.

Thanks as always!

Warm regards
Florian Dahn

Re: CreateDatabase does not work with ForeignKeys

Posted: Tue 08 Mar 2022 15:32
by Shalex
Please send us a test project with your model so that we can reproduce the issue in our environment.

Re: CreateDatabase does not work with ForeignKeys

Posted: Tue 08 Mar 2022 21:30
by FlorianDahn
Shalex wrote: Tue 08 Mar 2022 15:32 Please send us a test project with your model so that we can reproduce the issue in our environment.
I'll prepare something for you in the next 1-2 days.

Re: CreateDatabase does not work with ForeignKeys

Posted: Mon 14 Mar 2022 21:30
by FlorianDahn
Shalex wrote: Tue 08 Mar 2022 15:32 Please send us a test project with your model so that we can reproduce the issue in our environment.
Hey!

Sorry for the delay.
I had now prepared a test project, which raises the same exception.
I'll sent it to you by the provided link.

Thanks and hope to hear back from you soon!
Warm regards
Florian Dahn

Re: CreateDatabase does not work with ForeignKeys

Posted: Tue 15 Mar 2022 19:01
by Shalex
Thank you for the test project. We will investigate the issue and notify you about the result.

Re: CreateDatabase does not work with ForeignKeys

Posted: Tue 12 Apr 2022 16:20
by FlorianDahn
Shalex wrote: Tue 15 Mar 2022 19:01 Thank you for the test project. We will investigate the issue and notify you about the result.
Hey!

just wanna ask if you got some news on this thing?

Thanks!

Re: CreateDatabase does not work with ForeignKeys

Posted: Thu 28 Apr 2022 16:32
by Shalex
The investigation is in progress. An approximate timeframe for the fix is one month.

Re: CreateDatabase does not work with ForeignKeys

Posted: Fri 29 Apr 2022 12:23
by FlorianDahn
Shalex wrote: Thu 28 Apr 2022 16:32 The investigation is in progress. An approximate timeframe for the fix is one month.
Great, thanks for the follow up!