title: Using Dapper with SQL Spatial Types as a parameter
body: <p>I've got a system which basically has to do a query like this:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE @parameter.STIntersects(MyGeometryColumn)
  </code></pre>
  
  <p>This is quite simple to do when using vanilla SQL parameters, you just have to create your parameter in a non-typical way (where the builder variable is a SqlGeometryBuilder which I use to create a rectangle):</p>
  
  <pre><code>command.Parameters.Add(new SqlParameter
  {
      UdtTypeName = "geometry",
      Value = builder.ConstructedGeometry,
      ParameterName = "@paremeter"
  });
  </code></pre>
  
  <p>Now, When I try to do this using dapper, I get an error that it can't figure out how to use this as a parameter. Anyone who has got this working, or any pointers on how to enable this? I do have a workaround, but that involves using the string representation and converting that to a geometry type in my SQL query. I really don't want that.</p>
  
  <p>To answer the comment, the error I'm getting is 'The member Parameter of type Microsoft.SqlServer.Types.SqlGeometry cannot be used as a parameter value'. In other words, dapper doesn't know how to deal with a SqlGeometry object as a parameter.</p>