<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
  </startup>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="mssqllocaldb" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
<connectionStrings><add name="TestGeographyEntities" connectionString="metadata=res://*/TestGeography.csdl|res://*/TestGeography.ssdl|res://*/TestGeography.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=home-pc;initial catalog=TestGeography;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" /></connectionStrings></configuration>

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="EntityFramework" version="6.2.0" targetFramework="net461" />
  <package id="EntityFramework.ru" version="6.1.3" targetFramework="net461" />
  <package id="Microsoft.SqlServer.Types" version="14.0.314.76" targetFramework="net461" />
</packages>

namespace TestGeography
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    
    public partial class TestGeographyEntities : DbContext
    {
        public TestGeographyEntities()
            : base("name=TestGeographyEntities")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<Geo> Geos { get; set; }
        public virtual DbSet<WithoutGeo> WithoutGeos { get; set; }
    }
}

namespace TestGeography
{
    using System;
    using System.Collections.Generic;
    
    public partial class Geo
    {
        public int id { get; set; }
        public System.Data.Entity.Spatial.DbGeography Location { get; set; }
        public double Long { get; set; }
        public double Lat { get; set; }
    }
}

namespace TestGeography
{
    using System;
    using System.Collections.Generic;
    
    public partial class WithoutGeo
    {
        public int id { get; set; }
        public double Long { get; set; }
        public double Lat { get; set; }
    }
}

static void Main(string[] args)
        {
            SqlServerTypes.Utilities.LoadNativeAssemblies(AppDomain.CurrentDomain.BaseDirectory);
            var context = new TestGeographyEntities();
            IQueryable<WithoutGeo> query = context.WithoutGeos;
            List<WithoutGeo> listGeographicalKoordinates = query.ToList();

            foreach (var x in listGeographicalKoordinates)
                Console.WriteLine(x.Lat + " " + x.Long + ";" + "\n");
        }

static void Main(string[] args)
        {
            SqlServerTypes.Utilities.LoadNativeAssemblies(AppDomain.CurrentDomain.BaseDirectory);
            var context = new TestGeographyEntities();
            IQueryable<Geo> query = context.Geos;
            List<Geo> listGeographicalKoordinates = query.ToList();

            foreach (var x in listGeographicalKoordinates)
                Console.WriteLine(x.Lat + " " + x.Long + ";" + "\n");
        }

SqlProviderServices.SqlServerTypesAssemblyName = "Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"

SqlProviderServices.SqlServerTypesAssemblyName = "Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"