EF7 migration sql alter scripts

ef7sqlalterscripts.txt

migration.Sql("ALTER TABLE dbo.Availability ADD TotalHours AS DATEDIFF(SECOND,BeginTimeUtc,EndtimeUtc)/3600");
migration.Sql("ALTER TABLE dbo.PayRate ADD EstWeeklyRateLow AS HourlyRateLow*DesiredWeeklyHours");
migration.Sql("ALTER TABLE dbo.PayRate ADD EstWeeklyRateHigh AS HourlyRateHigh*DesiredWeeklyHours");
migration.Sql("ALTER TABLE dbo.Location ADD GeoPoint AS geography::Point(Latitude,Longitude, 4326)");
migration.Sql("ALTER TABLE dbo.ZipCodeLookup ADD GeoPoint AS geography::Point(Latitude,Longitude, 4326)");
migration.Sql("ALTER TABLE dbo.Contact ADD DisplayName AS FirstName + ' ' + LastName");
migration.Sql("ALTER TABLE dbo.Contact ADD LastNameFirst AS LastName + ', ' + FirstName");
migration.Sql("ALTER TABLE dbo.Contact ADD PublicName AS FirstName + ' ' + SUBSTRING(LastName, 1, 1) + '.'");