Handle an InvalidCastException using SQL CLR Data Types on Cloud Sites
Our clusters now have the MSSQL 2012 data types installed (assembly version 11.0) in addition to the MSSQL 2008 data types (assembly version 10.0). This may introduce errors for some custom applications.
In particular you may see this error when referencing SQLTypes from assembly version 11.0:
System.InvalidCastException: Unable to cast object of type 'Microsoft.SqlServer.Types.SqlGeometry' to type 'Microsoft.SqlServer.Types.SqlGeometry'.
This issue can be worked around in code or by specifying a value of “SQL Server 2012” for the “Type System Version” attribute in your connection string.
For code examples and more details, please see the “SQL CLR Data Types” section of this Microsoft document on changes in the SQL Server 2012 database engine:
Continue the conversation in the Rackspace Community.
©2016 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License