Why would SQLGeometry.STContains return null when the values being used are not null?
According to the documentation:
Returns null if the SRID of the two geography instances are not the same.
null
References: