verdie-g / StoredProcedureEFCore

Entity Framework Core extension to execute stored procedures
MIT License
192 stars 44 forks source link

Store procedure with geography column in EF Core #45

Open georgeemr opened 4 years ago

georgeemr commented 4 years ago

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.