A STUDY ON SPATIAL DATABASE FOR SQL SERVER 2008 WITH ENTITY FRAMEWORK 5.0

Rama Krishna Thotapally; DSR Murthy; T Phanindra Kumar

Volume : V, Issue : X, October - 2016

A STUDY ON SPATIAL DATABASE FOR SQL SERVER 2008 WITH ENTITY FRAMEWORK 5.0

Rama Krishna Thotapally, Dsr Murthy, T Phanindra Kumar

Abstract :

While spatial features have been in SQL Server for a while using those features inside of .NET applications hasn�t been as straight forward as could be, because .NET natively doesn�t support spatial types. There are workarounds for this with a few custom projects like SharpMap or a hack using the Sql Server specific Geo types found in the Microsoft.SqlTypes assembly that ships with SQL server. These approaches work for manipulating spatial data from .NET code, they didn�t work with database access if you�re using Entity Framework. Other ORM vendors have been rolling their own versions of spatial integration. In Entity Framework 5.0 running on .NET 4.5 the Microsoft ORM finally adds support for spatial types as well.