I'm trying to map some insert/update stored procedures to a table in EF. But one of my column types (string) in the stored procedure is different to the column in the table (geometry).
I have a Geometry column in the table that I want to populate in the stored procedure by passing it a string value.
Stored procedure:
CREATE PROCEDURE [dbo].[UpdatePLACE] 
    @globalid uniqueidentifier,
    @shapeString varchar(max) = null    
AS
BEGIN
    SET NOCOUNT ON;
    declare @shape as geometry  
    set @shape = geometry::STGeomFromText(@shapeString, 2193)
    UPDATE [dbo].[PLACE]
    SET [SHAPE] = @shape
    WHERE [globalid] = @globalid
END
So, is it possible to map a string to a geometry type and how?