In case you want to work with the sql server data types you would need to do the following
- Add a reference to the 'Microsoft.SqlServer.Types' assembly
- define the fields you require your class. For example - private SqlGeography geographyField;
- For each such field the mapping in the app.config file should be as follows
<extension key="db-column" value="mssql">
<extension key="db-type" value="LONGVARBINARY" />
<extension key="db-column-name" value="geographyColumn" />
<extension key="db-sql-type" value="geography" />
That's all that is required to work with spatial data types and classic approach.
Do get back in case you need further assistance.
the Telerik team
Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward!
We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>