Link to home
Start Free TrialLog in
Avatar of Ali Shah
Ali ShahFlag for United Kingdom of Great Britain and Northern Ireland

asked on

How to use spatial data types in SQL Server Database project

Hi guys,

I want to write the stored procedures and the UDF etc in managed code using C#CLR, however i am struggling to find the namespace to be used in SQL Database project type.

This name space https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.types.aspx has got the spatial data types but this is not available in the SQL Server Database project.

For instance i am writing a UDF in CLR managed code and i want to use the geography data type.

regards,
ASKER CERTIFIED SOLUTION
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ali Shah

ASKER

Thanks with your suggestion i was able to download the dll file and then added it as a reference and it worked. i suppose perhaps in SQL Server i would need to register that dll.

regards,