Developer technologies | .NET | Other
Microsoft Technologies based on the .NET software framework. Miscellaneous topics that do not fit into specific categories.
No mapping exists from object type Microsoft.SqlServer.Types.SqlGeography to a known managed provider native type.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 4%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tom van Oost
0
Reputation points
I'm receiving the following error when storing data with DbGeography type in the database, using Entity Framework 6.4.4 and .NET 6:
No mapping exists from object type Microsoft.SqlServer.Types.SqlGeography to a known managed provider native type.
Using the latest version of Microsoft.SqlServer.Types: 160.1000.6.
Stacktrace:
System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details.
---> System.Data.Entity.Core.EntityCommandCompilationException: An error occurred while preparing the command definition. See the inner exception for details.
---> System.ArgumentException: No mapping exists from object type Microsoft.SqlServer.Types.SqlGeography to a known managed provider native type.
at System.Data.SqlClient.MetaType.GetMetaTypeFromValue(Type dataType, Object value, Boolean inferLen, Boolean streamAllowed)
at System.Data.SqlClient.MetaType.GetMetaTypeFromType(Type dataType)
at System.Data.SqlClient.SqlParameter.GetMetaTypeOnly()
at System.Data.SqlClient.SqlParameter.get_SqlDbType()
Developer technologies | .NET | Other
{count} votes
-
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator2023-03-13T22:20:25.99+00:00 Shouldn't you add a tag that targets Entity Framework? Because it is EF that is producing this error isn't it?
-
Jack J Jun 25,316 Reputation points2023-03-14T06:40:46.56+00:00 @Tom van Oost, Welcome to Microsoft Q&A, could you provide some steps or some code with me so that I could reproduce your problem? Also, I noted that you used package
EntityFrameworkin a .NET 6 app, right? As usual,EnityFrameworkis used in a .NET Framework app. For .NET 6 app, we need to use the packageMicrosoft.EntityFrameworkCore. -
Jack J Jun 25,316 Reputation points
2023-03-21T14:21:18.4133333+00:00 @Tom van Oost, is any update?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 7.000000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Randy Shoopman 0 Reputation points2023-04-05T18:06:11.0766667+00:00 I am receiving this same error when trying to save an EF6 context with a DbGeography property on my model.
public System.Data.Entity.Spatial.DbGeography GeoLocation { get; set; } // how it's set it decimal latitude, decimal longitude var pointWKT = $"POINT({longitude} {latitude})"; GeoLocation = DbGeography.FromText(pointWKT, 4326);Libraries:
.net 6
EF 6.4.4
Microsoft.SqlServer.Types 160.1000.6I saw on stackoverflow the ErikEJ.EntityFramework.SqlServer provider workaround but I'd rather not do all the config necessary to replace the provider. Is there something I can change in my code to fix this? If it's a bug is there going to be fixed in EntityFramework 6.5? Thanks
Sign in to comment
Sign in to answer