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());
}
}
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();
}
using (var db = new RenamedAndReorderedContext())
{
var 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();
}
using (var db = new RenamedAndReorderedContext())
{
var 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);
}
}
public void UpdateAll_IncrementDateTime_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();
}
using (var db = new RenamedAndReorderedContext())
{
var count = EFBatchOperation.For(db, db.BlogPosts).Where(b => b.Title == "T2").Update(b => b.Created, b => DbFunctions.AddDays(b.Created, 1));
Assert.AreEqual(1, count);
}
using (var db = new RenamedAndReorderedContext())
{
var post = db.BlogPosts.First(p => p.Title == "T2");
Assert.AreEqual(new DateTime(2013, 02, 02), post.Created);
}
}
