Page 1 of 1

Geography property in complex type

Posted: Thu 10 Sep 2020 12:41
by frabiacca
Hi guys,
I created a Devart EF Core model and a Complex type inside (called "Luogo" aka "Location).

Luogo complex type is composed by some properties, like "PosizioneGEO" of type
"Geography".

I update model and db (sql server 2014) correctly but when I run the application (asp.net mvc
core) it appears this error:
InvalidOperationException: The property 'Fattura.ClienteIndirizzo#Luogo.PosizioneGeo' is of type 'Geometry' which is not supported by current database provider. Either change the property CLR type or ignore the property using the '[NotMapped]' attribute or by using 'EntityTypeBuilder.Ignore' in 'OnModelCreating'.
How can I manage this error ?
What's the source of it ?

Re: Geography property in complex type

Posted: Fri 11 Sep 2020 16:23
by Shalex
We have reproduced the issue and will notify you when it is fixed.

Re: Geography property in complex type

Posted: Mon 21 Sep 2020 13:16
by Shalex
The bug with using spatial types inside complex types in EF Core Model is fixed in v6.9.1083: viewtopic.php?f=32&t=42253.