public void LetsDoThis()
        {
            //contexts
            var old = new RentlerBackupEntities();
            var db = new New.RentlerNewEntities();

            //diagnostics
            Stopwatch watch = new Stopwatch();

            Console.WriteLine("Getting apiKeys");
            var apiKeys = old.ApiKeys.ToList().Select(s => new New.ApiKey
            {
                ApiKeyId = s.ApiKeyId,
                IpAddress = s.IpAddress,
                IsDeleted = s.IsDeleted,
                Name = s.Name,
                UserId = s.UserId
            });

            Console.WriteLine("Adding them to the db.");
            foreach(var item in apiKeys)
                db.ApiKeys.AddObject(item);

            db.SaveChanges();
            Console.WriteLine("Done, moving on to affiliate users");

            var affiliateUsers = old.AffiliateUsers.ToList().Select(s => new New.AffiliateUser
            {
                AffiliateUserKey = s.AffiliateUserKey,
                ApiKey = s.ApiKey,
                IsDeleted = s.IsDeleted,
                PasswordHash = s.PasswordHash,
                UserId = s.UserId
            });

            Console.WriteLine("Got 'em, adding to db");
            foreach(var item in affiliateUsers)
                db.AffiliateUsers.AddObject(item);

            db.SaveChanges();
            Console.WriteLine("Done!");
        }
        public void LetsDoThis()
        {
            //contexts
            var old = new RentlerBackupEntities();
            var db = new New.RentlerNewEntities();

            //diagnostics
            Stopwatch watch = new Stopwatch();

            var custom = (from s in old.Buildings
                          from p in s.PropertyInfo.CustomAmenities
                          select new { Custom = p, BuildingId = s.BuildingId }).ToList()
                            .Select(e => e.Custom.ToNewCustomAmenity(e.BuildingId)).ToList();

            db.Connection.Open();
            var trans = db.Connection.BeginTransaction();
            Console.WriteLine("Turning Identity Insert on");
            db.ExecuteStoreCommand("SET IDENTITY_INSERT CustomAmenities ON");

            foreach(var item in custom)
                db.CustomAmenities.AddObject(item);

            db.SaveChanges(false);

            Console.WriteLine("Turning identity insert off...");
            db.ExecuteStoreCommand("SET IDENTITY_INSERT CustomAmenities OFF");

            Console.WriteLine("Committing transaction...");
            trans.Commit();
            Console.WriteLine("Accepting changes...");
            db.AcceptAllChanges();
            Console.WriteLine("Closing connection...");
            db.Connection.Close();
            Console.WriteLine("Custom Amenities are in.");
            Console.ReadLine();
        }
        public void LetsDoThis()
        {
            //contexts
            var old = new RentlerBackupEntities();
            var db = new New.RentlerNewEntities();
            var withoutTracing = new New.RentlerNewEntities();

            //diagnostics
            Stopwatch watch = new Stopwatch();

            var map = (from b in old.Buildings
                       where b.PropertyInfoId != null
                       select new
                       {
                           BuildingId = b.BuildingId,
                           PropertyInfoId = b.PropertyInfoId.Value
                       }).ToList();

            Dictionary<int, int> dict = new Dictionary<int, int>();
            foreach(var item in map)
                dict[item.PropertyInfoId] = item.BuildingId;

            //save the endangered RAMS
            map = null;

            var amen = old.PropertyInfoAmenities.ToList();
            var newamen = new List<New.BuildingAmenity>();

            foreach(var item in amen)
            {
                if(dict.ContainsKey(item.PropertyInfoId))
                    newamen.Add(new New.BuildingAmenity
                           {
                               AmenityId = item.AmenityId,
                               CreateDate = item.CreateDate,
                               CreatedBy = item.CreatedBy,
                               UpdateDate = item.UpdateDate,
                               UpdatedBy = item.UpdatedBy,
                               IsDeleted = item.IsDeleted,
                               BuildingId = dict[item.PropertyInfoId]
                           });
            }

            //more endangered RAMS
            amen = null;

            StringBuilder script = new StringBuilder();

            var updated = DateTime.UtcNow.ToString();
            script.AppendLine("use RentlerNew;");
            int count = 0;
            foreach(var item in newamen)
            {
                if(count == 100)
                {
                    count = 0;
                    script.AppendLine("GO");
                }
                script.AppendLine(string.Format(
                    "insert into BuildingAmenities values({0}, {1}, \'{2}\', \'{3}\', \'{4}\', \'{5}\', {6})",
                    item.AmenityId, item.BuildingId, updated,
                    "weblinq", item.CreateDate.ToString(), item.CreatedBy.ToString(),
                    item.IsDeleted ? "1" : "0"));
                count++;
            }

            var file = File.CreateText("buildingamenities.sql");
            file.Write(script.ToString());
            file.Flush();
            file.Close();
            Console.WriteLine("Done generating script; pause here and run it. File: buildingamenities.sql");
            Console.ReadLine();
        }