CreateDatabase does not work with ForeignKeys
-
- Posts: 26
- Joined: Thu 06 Feb 2020 18:23
CreateDatabase does not work with ForeignKeys
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
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
Please send us a test project with your model so that we can reproduce the issue in our environment.
-
- Posts: 26
- Joined: Thu 06 Feb 2020 18:23
-
- Posts: 26
- Joined: Thu 06 Feb 2020 18:23
Re: CreateDatabase does not work with ForeignKeys
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
Thank you for the test project. We will investigate the issue and notify you about the result.
-
- Posts: 26
- Joined: Thu 06 Feb 2020 18:23
Re: CreateDatabase does not work with ForeignKeys
The investigation is in progress. An approximate timeframe for the fix is one month.
-
- Posts: 26
- Joined: Thu 06 Feb 2020 18:23