verdie-g/StoredProcedureEFCore

Store procedure with geography column in EF Core

georgeemr opened this issue · 0 comments

When I call a store procedure with a geography column in EF Core i'm getting the error.

Model:
public Geometry Coordenates { get; set; }

g.db.LoadStoredProc("dbo.spGetCoordenates").AddParam("UsuarioId", c.Id).Exec(r => uDatoExtraModel = r.FirstOrDefault());

FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. The system cannot find the file specified. This library is for Net Framework.