Monday, January 14, 2013 3:54 PM
I am using Version 2012. In my c#-app i am using the Microsoft.SqlServer.Types-lib version 11. But if I query any spatial data, the Microsoft.SqlServer.Types-lib version 10 is used by the server. How can I tell sql-server to use the newer version 11 of this lib?
Monday, January 14, 2013 4:16 PMGot the solution here: http://technet.microsoft.com/en-us/library/ms143179.aspx
- Marked As Answer by Papy NormandModerator Monday, January 14, 2013 5:44 PM
Monday, January 14, 2013 5:44 PMModerator
Please, for the next time you will post a link , could you provide a link which is clickable ? It is making easier the use of the link.
The solution is OK, except that it is not useable with .Net Framework purely 4.0 :
in the part "SQL CLR Data Types (geometry, geography, and hierarchyid)", i found :
'You can work around this issue in your connection string by specifying a value of "SQL Server 2012" for the "Type System Version" attribute to force SqlClient to load version 11.0 of the assembly. This connection string attribute is available only in .NET 4.5 and above'.
I have not tested , but i think it is not useable with Visual Studio 2010.
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.