public void UpdateAll_SetDateTimeValueFromVariable_RenamedColumn()
      {
          RenamedAndReorderedContext.SetupTestDb();
          using (var db = new RenamedAndReorderedContext())
          {
              db.BlogPosts.Add(new RenamedAndReorderedBlogPost { Title = "T1", Created = new DateTime(2013, 01, 01) });
              db.BlogPosts.Add(new RenamedAndReorderedBlogPost { Title = "T2", Created = new DateTime(2013, 02, 01) });
              db.BlogPosts.Add(new RenamedAndReorderedBlogPost { Title = "T3", Created = new DateTime(2013, 03, 01) });

              db.SaveChanges();
          }

          int count;
          using (var db = new RenamedAndReorderedContext())
          {
              count = EFBatchOperation.For(db, db.BlogPosts).Where(b => b.Title == "T2").Update(b => b.Created, b => DateTime.Today);
              Assert.AreEqual(1, count);
          }

          using (var db = new RenamedAndReorderedContext())
          {
              var post = db.BlogPosts.First(p => p.Title == "T2");
              Assert.AreEqual(DateTime.Today, post.Created);
          }
      }
      public void UpdateAll_IncrementIntValue_RenamedColumn()
      {
          RenamedAndReorderedContext.SetupTestDb();
          using (var db = new RenamedAndReorderedContext())
          {
              db.BlogPosts.Add(new RenamedAndReorderedBlogPost { Title = "T1", Created = new DateTime(2013, 01, 01) });
              db.BlogPosts.Add(new RenamedAndReorderedBlogPost { Title = "T2", Created = new DateTime(2013, 02, 01), Reads = 10 });
              db.BlogPosts.Add(new RenamedAndReorderedBlogPost { Title = "T3", Created = new DateTime(2013, 03, 01) });

              db.SaveChanges();
          }

          int count;
          using (var db = new RenamedAndReorderedContext())
          {
              count = EFBatchOperation.For(db, db.BlogPosts).Where(b => b.Title == "T2").Update(b => b.Reads, b => b.Reads + 100);
              Assert.AreEqual(1, count);
          }

          using (var db = new RenamedAndReorderedContext())
          {
              var post = db.BlogPosts.First(p => p.Title == "T2");
              Assert.AreEqual(110, post.Reads);
          }
      }    
Exemplo n.º 3
0
 public static void SetupTestDb()
 {
     using (var db = new RenamedAndReorderedContext())
     {
         if (db.Database.Exists())
         {
             db.Database.Delete();
         }
         db.Database.Create();
         db.Database.ExecuteSqlCommand("drop table dbo.RenamedAndReorderedBlogPosts;");
         db.Database.ExecuteSqlCommand(RenamedAndReorderedBlogPost.CreateTableSql());
     }
 }
 public static void SetupTestDb()
 {
     using (var db = new RenamedAndReorderedContext())
     {
         if (db.Database.Exists())
         {
             db.Database.Delete();
         }
         db.Database.Create();
         db.Database.ExecuteSqlCommand("drop table dbo.RenamedAndReorderedBlogPosts;");
         db.Database.ExecuteSqlCommand(RenamedAndReorderedBlogPost.CreateTableSql());
     }
 }
        public void InsertAll_WrongColumnOrderAndRenamedColumn_InsertsItems()
        {
            using (var db = new RenamedAndReorderedContext())
            {
                if (db.Database.Exists())
                {
                    db.Database.Delete();
                }
                db.Database.Create();
                db.Database.ExecuteSqlCommand("drop table dbo.RenamedAndReorderedBlogPosts;");
                db.Database.ExecuteSqlCommand(RenamedAndReorderedBlogPost.CreateTableSql());
            }

            using (var db = new RenamedAndReorderedContext())
            {

                var list = new List<RenamedAndReorderedBlogPost>(){
                    RenamedAndReorderedBlogPost.Create("T1"),
                    RenamedAndReorderedBlogPost.Create("T2"),
                    RenamedAndReorderedBlogPost.Create("T3")
                };

                EFBatchOperation.For(db, db.BlogPosts).InsertAll(list);
            }

            using (var db = new RenamedAndReorderedContext())
            {
                Assert.AreEqual(3, db.BlogPosts.Count());
            }
        }