Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Microsoft.SqlServer.Types

Answered Microsoft.SqlServer.Types

  • Monday, January 14, 2013 3:54 PM
     
     
    Sign In to Vote
    0

    Hi

    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?

    Thank you.

    Adrian

     

All Replies

  • Monday, January 14, 2013 4:16 PM
     
     Answered
    Sign In to Vote
    0
    Got the solution here: http://technet.microsoft.com/en-us/library/ms143179.aspx
     
  • Monday, January 14, 2013 5:44 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello Meyersche,

    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.