Spatial types and functions are not available for this provider

entity-framework-6 sql sql-server visual-studio-2015

Question

I have Visual studio 2015 community Edition with Update 3. I am using Entity Framework 6. On running the project on my local I am getting the error as shown in screen shot(https://puu.sh/uXFh0/64648902af.png). As in the code I am using c.Geography; its showing exception at that point.

I have Sql Server 2016 installed on my system with CLR Types as shown in below screen shot https://puu.sh/uXFqy/9f3c56a329.png

I also installed Sql server types using nuget package Install-Package Microsoft.SqlServer.Types.

Still no luck. what else can I do to solve the issue?

1
0
3/25/2017 5:49:27 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You have multiple versions of the CLR types installed so you need to tell your application which version to use. Not sure what type of application it is but you need to either put these lines of code in your global.asax.cs (web app):

SqlServerTypes.Utilities.LoadNativeAssemblies(Server.MapPath("~/bin"));
SqlProviderServices.SqlServerTypesAssemblyName = "Microsoft.SqlServer.Types, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91";

or else this in your desktop app prior to the spatial code running:

SqlServerTypes.Utilities.LoadNativeAssemblies(AppDomain.CurrentDomain.BaseDirectory);
SqlProviderServices.SqlServerTypesAssemblyName = "Microsoft.SqlServer.Types, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91";
1
3/28/2017 3:57:23 PM

Related Questions

No mapping exists from object type System.RuntimeType to a known managed provider native type

You are missing ouput settings for your sqlparameters and @. Your code should look something like this:...SqlParameter pScanCode = new SqlParameter("@ScanCode", ScanCode); SqlParameter opName = new SqlParameter("@Name", name); opName.Direction = System.Data.ParameterDirection.Output; //Important! SqlParameter opScanTime = new SqlParameter("@ScanT...
entity-framework
asked by Gregor Primar

Spatial DataReader and Wrapping Providers in EF6

It seems like a bug in the provider model. SqlProviderServices converts EDM spatial types to SqlServer spatial types in the SetParameterValue method however there is no public way to call this method from your wrapping provider. I created a bug for tracking this: ...https://entityframework.codeplex.com/workitem/1867.... An ugly workaround would be...
entity-framework entity-framework-6
asked by Pawel

The FK relationship was not loaded because the type is not available

In one of our C# batch jobs, we use a dll that was built using the Entity Framewok 4.1. The batch job, however, also uses the EF (same version) and it looks like this might be causing some trouble. ...In both the dll and batch job's ....edmx... files is a relationship between the ...AgentTransmission... and ...AgentRelationshipCodes... table. ...Ag...
c# dll entity-framework
asked by NealR

Error 6046: Unable to generate function import return type of the store function

Preceding answers show the good way to solve the problem but none works in real life....Here's a tested solution with ...Entity Framework 6... that works for me. So it should works for you....Import your scalar valued function...Import your scalar valued function ...[FRM].[GetContentByIdAndCul]... into your Entity Framework model. It automatically ...
entity-framework linq sql-function
asked by Gael

Spatial DbGeography Provider exception with Effort.EF6 [No usable spatial provider could be found.]

Given that Effort doesn't not support special properties like DbGeography and tamasflamich says ...here...:...There is no existing support (not even beta) and I am not planning to start work on this feature anytime soon. Sorry....I also tried to use ...Highway.Data... but it doesn't support neither....It does not now, nor will it ever support Adv...
asp.net-mvc c# effort entity-framework-6 spatial
asked by nramirez

Unable to determine the provider name for provider factory of type "System.Data.Sqlite.SqliteFactory"

I want to use sqlite entity framework in my web api project, but it always can't work well, ...here is my development enviroment....1.Visual studio 2013, .net framework 4.5...sqlite package version is 1.0.97, I installed below packages...system.data.sqlite, system.data.sqlite.ef6, system.data.sqlite.linq...EntityFramework is 6.1.3...Here is excep...
c# entity-framework entity-framework-6 sqlite visual-studio-2013
asked by zhnglicho

The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' could not be loaded

I created a WCF Service using dotNet 4.5. The database layer is built with Entity Framework 6....I hosted the service with IIS 8. It is working fine....Now I need to consume the service with windows forms client, that is built using dotnet framework 3.5. ...I can create the service reference successfully. But when I run the code, getting the follo...
.net entity-framework wcf winforms
asked by Ali Sakhi

How to use SqlServer.Types / spatial types within ASP.NET Core 1.0 application

I got this working on an ASP.NET Core application today (.NET Framework underneath, not .NET Core, same as the original poster)....The thing I noticed is that adding the Nuget package directly to my ASP.NET Core site yielded no additional files. Not sure if the packages were ever updated to work with ASP.NET Core?...At any rate, I just added the pa...
asp.net asp.net-core asp.net-core-1.0 entity-framework-6
asked by Nick Albrecht

Property type of 'System.Data.Entity.Spatial.DbGeography' which cannot be mapped to a primitive type

We finally figured out what our problem was. I'll post hoping it may help someone else. We were using Entity Data Source with a few of our controls and this is no longer supported with EF 6. ...Here's the corresponding stack overflow Q/A that helped us: ...EntityDataSource and Entity Framework 6
c# entity-framework-6 spatial-data visual-studio-2015
asked by Brian

The store type 'Varchar(100)' could not be found in the SqlServer provider manifest

This is the error I am getting: The store type 'Varchar(100)' could not be found in the SqlServer provider manifest...This is because it's invalid, as mentioned in my comment above, you can't pass the length of the type in ...HasColumnType.... To fix this please see below....public EntityAConfiguration() { this.ToTable("EntityA"...
asp.net-mvc c# entity-framework entity-framework-6 sql-server
asked by Çöđěxěŕ

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow