Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can no longer create foreign key on SQLite with FluentMigrator.Runner 5.2.0 #1784

Open
DmitriyKulagin opened this issue Apr 18, 2024 · 0 comments

Comments

@DmitriyKulagin
Copy link

Describe the bug
A migration for a table that includes an foreign key column and one other primary key columns are broken for Sqlite in 5.2.0 version.
I get the following error:

----> FluentMigrator.Exceptions.DatabaseOperationNotSupportedException : Foreign keys are not supported in SQLite

To Reproduce
Create a foreign key like this:

Create.ForeignKey("fk_TestTable2_TestTableId_TestTable_Id")
			.FromTable("TestTable2").ForeignColumn("TestTableId")
			.ToTable("TestTable").PrimaryColumn("Id");

Expected behavior
I expect to be able to create a foreign key in SQLite, like in earlier versions of FluentMigrator.Runner

Information (please complete the following information):
OS: Windows 11
Platform: .NET 8
FluentMigrator version: 5.2.0
FluentMigrator runner: in process
Database Management System: SQLite
Database Management System Version: Microsoft.Data.Sqlite 8.0.4

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant