Entity Framework Migrations Computed Column for DbGeography Location, Tme and Cost

efMigration_Sample.cs

Sql("ALTER TABLE dbo.Profile ADD DisplayName AS FirstName + ' ' + LastName");
Sql("ALTER TABLE dbo.Profile ADD LastNameFirst AS LastName + ', ' + FirstName");
Sql("ALTER TABLE dbo.Profile ADD PublicName AS FirstName + ' ' + SUBSTRING(LastName, 1, 1) + '.'");
Sql("ALTER TABLE dbo.Availability ADD TotalHours AS DATEDIFF(SECOND,BeginTime,Endtime)/3600");
Sql("ALTER TABLE dbo.Rate ADD EstWeeklyRateLow AS HourlyRateLow*DesiredWeeklyHours");
Sql("ALTER TABLE dbo.Rate ADD EstWeeklyRateHigh AS HourlyRateHigh*DesiredWeeklyHours");
Sql("ALTER TABLE dbo.LocationData ADD Location AS geography::Point(Latitude,Longitude, 4326)");
Sql("ALTER TABLE dbo.RefZipCode ADD Location AS geography::Point(Latitude,Longitude, 4326)");