title: Using SQL Server 2012 Geography Data Type with ASP.Net - DataReader.GetFieldType(x) returned null
body: <p>I've written an ASP.Net 4 Application which has been working perfectly. However, I decided to make use of the new Geography Data Type in Sql Sever 2012. This worked perfectly on my local machine but fails when I upload. </p>
  
  <p>I get there error "DataReader.GetFieldType(9) returned null." when doing a usual "select * FROM Table" query on a table that contains one of these datatypes.</p>
  
  <p>I have searched the various threads regarding adding a reference to the Microsoft.SqlServer.Types.dll into my project and changing Copy Local to true. However I am getting the same error.</p>
  
  <p>I run the database and the web server on two separate servers so I don't think there are any assemblies on the web server unless I upload them with my project. </p>
  
  <p>Am I missing any other assemblies that are needed? or any other settings?</p>
  
  <p>I've taken days trying to solve this and uploading variouse libraries. Any help would be appreciated.</p>