Symptoms

Whenever I execute a Create on a SmartObject (SQL Server service instance) that has a geography datatype, I get an error that says "Nullable object must have a value"
 

Diagnoses

Unfortunately, the 'geography' data type is not yet supported resulting in the 'Nullable object must have a value' error that we are experiencing. It would seem the "Read", "List" and "Delete" does execute correctly, but the "Create" and "Update" will result in this error. As such one possible implementation is to perhaps create a stored proc that will handle the "Create" and "Update" method.

As it looks like a geography data type will require a (geography::STGeomFromText, geography::Point, geography::Parse, etc.) call in the stored proc to make the conversion to the geography data type.

http://www.sql-server-helper.com/sql-server-2008/convert-latitude-longitude-to-geography-point.aspx
 

Resolution

A feature request for support of this data type in a future release had been logged and our documentation will be updated accordingly