develop dotnet core application to measure distance

Task: Create a DotNet Core console application (or MVC application) to calculate distances between source and destination. I would like to use Google APIs to do these calculations, as well as SQL Server to do the same. In [login to view URL] you create an option to indicate whether to use Google or SQL Server method to perform the calculations. Functionalities: 1 - Geocode: transform a pair of coordinates into a full address, inclusing streetname, number, postalcode, neighborhood, city, state, country     The coordinates must be stored in SQL Server / DotNet Core Geography datatype (tipo 4326) 2 - Geodecode: transform an address into a pair of coordinates     The coordinates must be stored in SQL Server / DotNet Core Geography datatype (tipo 4326) 3 - Calculate distances using these methods:     a) Between 2 addresses     b) Between 2 geographic coordinates        Provide an implementation using SQL Server (I provide some source code below) and one with Google APIs c) Between an address and 1 geographic coordinate d) Between a geographic coordinate and 1 address 4 - Show the source and destination coordinates / addresses on the map, with a symbol which indicates the start and end positions     and a straight line between these coordinates Deliverables: Visual Studio 2017 Solution with 1 DotNet Core 2.1 project which implements the requirements. ------------------------------------------------------------------------------------------------------------------- Some useful information: CREATE TABLE [dbo].[CitiesWorld]( [Id] [smallint] IDENTITY(1,1) NOT NULL, [City] [nchar](40) NULL, [Coordinates] [geography] NULL, CONSTRAINT [PK_CitiesWorld] PRIMARY KEY CLUSTERED  ( [Id] ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO INSERT INTO [dbo].[CitiesWorld] ([City],[Coordinates]) VALUES ('Cochabamba', geography::STGeomFromText('POINT(-66.1711278 -17.4125)', 4326)); GO INSERT INTO [dbo].[CitiesWorld]([City],[Coordinates]) VALUES('London', geography::STGeomFromText('POINT(0.0275361 51.5064694)', 4326)); GO CREATE PROCEDURE Distance @cityor varchar(50), @citydest varchar(50), @unit varchar(5) AS declare @or geography, @dest  geography SET @or = (select coordinates from [dbo].[CitiesWorld] where city=@cityor) SET @dest = (select coordinates from [dbo].[CitiesWorld] where city=@citydest) IF @unit='miles' SELECT @[login to view URL](@dest)/1609.344 ELSE --Else show the distance in km SELECT @[login to view URL](@dest)/1000   EXECUTE Distance 'Cochabamba','London','miles' EXECUTE Distance 'Cochabamba','London','km' -- *** Calculate the distance in KM between 2 points *** DECLARE @source geography = 'POINT(0 51.5)' DECLARE @target geography = 'POINT(-3 56)' SELECT @[login to view URL](@target) as [Distance in KM] -- *** Function *** CREATE FUNCTION [login to view URL] ( @source VARCHAR(40), @destination VARCHAR(40) ) RETURNS FLOAT  AS BEGIN DECLARE @g geography; DECLARE @h geography; DECLARE @distance float; SET @g = geography::STGeomFromText('POINT(' + @source + ')', 4326); SET @h = geography::STGeomFromText('POINT(' + @destination + ')', 4326); SET @distance = (SELECT @[login to view URL] (@h) as [Distance in Meters]) Return @distance END -- *** [login to view URL] *** -- *** Call the SQL Server Function *** select [dbo].[fnCalcDistanceMeters] ('-23.5766949 -46.6871394', '-23.4943056 -46.8038278')  as [Distance in Meters] --Distance: 14418,9109882281 meters