static void Main(string[] args) { var builds = RBuild.Select(); MBuild mBuildObj = new MBuild(); foreach (var build in builds) { var mBuild = mBuildObj.SelectByLegacyId(build.Id); if (mBuild != null) { bool isSame = mBuild.BuildTime == build.BuildTime; if (!isSame) { Console.WriteLine($"{build.FullBuildString}: {build.BuildTime} != {mBuild.BuildTime}"); DateTime dt = DateTime.SpecifyKind(build.BuildTime.Value, DateTimeKind.Utc); mBuildObj.UpdateDateOfLegacy(build.Id, dt); } } } Console.ReadKey(); }
static void Main(string[] args) { var builds = from b in RBuild.Select() select new MBuildModel() { Id = Guid.NewGuid(), LegacyId = b.Id, MajorVersion = b.MajorVersion, MinorVersion = b.MinorVersion, Number = b.Number, Revision = b.Revision, Lab = b.Lab, BuildTime = b.BuildTime.HasValue ? DateTime.SpecifyKind(b.BuildTime.Value, DateTimeKind.Utc) as DateTime? : null as DateTime?, Added = DateTime.SpecifyKind(b.Added, DateTimeKind.Utc), Modified = DateTime.SpecifyKind(b.Modified, DateTimeKind.Utc), SourceType = b.SourceType, SourceDetails = b.SourceDetails, LeakDate = b.LeakDate.HasValue ? DateTime.SpecifyKind(b.LeakDate.Value, DateTimeKind.Utc) as DateTime? : null as DateTime?, FlightLevel = ExchangeFlights(b.FlightLevel), LabUrl = b.GenerateLabUrl() }; MBuild mb = new MBuild(); mb.InsertAll(builds); Console.WriteLine("Builds: Complete"); var metas = from b in RMetaItem.Select() select new MMetaItemModel() { Id = new MetaItemKey() { Type = b.Id.Type, Value = b.Id.Value }, MetaDescription = b.MetaDescription, PageContent = b.PageContent }; MMetaItem mmi = new MMetaItem(); mmi.InsertAll(metas); Console.WriteLine("Meta Item: Complete"); var members = from r in RMember.Select() select new MMemberModel() { CreationDate = r.CreationDate, EmailAddress = r.EmailAddress, Id = r.Id, IsApproved = r.IsApproved, IsLockedOut = r.IsLockedOut, LastActivityDate = r.LastActivityDate, LastLockoutDate = r.LastLockoutDate, LastLoginDate = r.LastLoginDate, LockoutWindowAttempts = r.LockoutWindowAttempts, LockoutWindowStart = r.LockoutWindowStart, PassHash = r.PassHash, PassSalt = r.PassSalt, UserName = r.UserName }; MMember mm = new MMember(); mm.InsertAll(members); Console.WriteLine("Members: Complete"); var roles = from r in RRole.Select() select new MRoleModel() { Id = r.Id, RoleName = r.RoleName, Users = r.Users }; MRole mr = new MRole(); mr.InsertAll(roles); Console.WriteLine("Roles: Complete"); Console.ReadKey(); }