Create fails when script uses SQL Server 2008 Spatial types

The script execution can fail when the script uses the SQL Server 2008 spatial API because it uses "::". dbversion uses NHibernate queries to execute scripts which parse colons as named parameters.

To solve this we can grab the connection from the hibernate session and create a command from it.

Here's some example code that can fail:

CREATE FUNCTION [dbo].[llAreasNearLocation]
(
 @Latitude float,
 @Longitude float,
 @RadiusMetres int
)
RETURNS TABLE
AS
RETURN
(
 select *
 from
 (select geography::Point(@Latitude, @Longitude, 4326).STDistance(Location) "Distance",
  *
 from GeographicArea) dist
 where dist.Distance <= @RadiusMetres
)