CreateDatabase does not work with ForeignKeys

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
FlorianDahn
Posts: 26
Joined: Thu 06 Feb 2020 18:23

CreateDatabase does not work with ForeignKeys

Post by FlorianDahn » Fri 04 Mar 2022 14:32

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: CreateDatabase does not work with ForeignKeys

Post by Shalex » 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.

FlorianDahn
Posts: 26
Joined: Thu 06 Feb 2020 18:23

Re: CreateDatabase does not work with ForeignKeys

Post by FlorianDahn » Tue 08 Mar 2022 21:30

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.

FlorianDahn
Posts: 26
Joined: Thu 06 Feb 2020 18:23

Re: CreateDatabase does not work with ForeignKeys

Post by FlorianDahn » Mon 14 Mar 2022 21:30

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: CreateDatabase does not work with ForeignKeys

Post by Shalex » Tue 15 Mar 2022 19:01

Thank you for the test project. We will investigate the issue and notify you about the result.

FlorianDahn
Posts: 26
Joined: Thu 06 Feb 2020 18:23

Re: CreateDatabase does not work with ForeignKeys

Post by FlorianDahn » Tue 12 Apr 2022 16:20

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!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: CreateDatabase does not work with ForeignKeys

Post by Shalex » Thu 28 Apr 2022 16:32

The investigation is in progress. An approximate timeframe for the fix is one month.

FlorianDahn
Posts: 26
Joined: Thu 06 Feb 2020 18:23

Re: CreateDatabase does not work with ForeignKeys

Post by FlorianDahn » Fri 29 Apr 2022 12:23

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!

Post Reply