Repository navigation
Index reported as Extra in Database, but it is also in the model. #33
Description
Hi, I am using SQL Server, and I am getting the following errors.
EXTRA IN DATABASE: Index 'AuthorityStandards', index constraint name. Found = IX_AuthorityStandards_ExtId
EXTRA IN DATABASE: Index 'AuthorityStandards', index constraint name. Found = IX_AuthorityStandards_GradeLevelId
EXTRA IN DATABASE: Index 'AuthorityStandards', index constraint name. Found = IX_AuthorityStandards_SubjectId
EXTRA IN DATABASE: Index 'AuthorityStandards', index constraint name. Found = IX_AuthorityStandards_AuthorityId_SubjectId_GradeLevelId_Name_YearAdopted
My entity class is decorated accordingly
The GradeLevelId and SubjectId are there because they are FK to another table.
As I was writing this bug report I thought that maybe this had to do with another bug report I created earlier.
Errors when using JSON columns
Since the error in both bug reports happen to be in tables where both have a JSON column. So I went ahead and removed the JSON column with a migration from this table AuthorityStandards and the error reported above went away! In other words these errors are reported only when there is a JSON column present in the table.
I hope this helps
Reacted by Carlos Martos
Reacted by Carlos Martos
Activity
CSharpFiasco commentedon Feb 23, 2024
I have a similar issue when I use a value object. The error message I get is:
I have simplified my project and recreated this issue here. I subsequently created another branch which removed the ShippingAddress field off of the Order entity here. The unit test that does the comparison succeeds when I remove the ShippingAddress field
By the way, here is some information on my system
I am using:
EfCore.SchemaCompare 8.0.1
Visual Studio 2022 Version 17.8.7
SQL Server 15 (the tests write to the (localdb)\mssqllocaldb)
EF Core 8
JonPSmith commentedon Oct 18, 2024
Hi @urielzen,
Do try version 8.1.0, which supports Json Mapping, and close this if it works. Thanks.