public InitializerTests() { _db = new SpyStoreContext(); StoreDataInitializer.InitializeData(_db); }
public static void CleanDataBase(SpyStoreContext context, string tableName) { context.Database.ExecuteSqlCommand($"Delete from {tableName}"); context.Database.ExecuteSqlCommand($"DBCC CHECKIDENT (\"{tableName}\", RESEED, 1);"); }
public static void CleanDataBase(SpyStoreContext context) { }
public CategoryTests() { _db = new SpyStoreContext(); DatabaseUtilities.CleanDataBase(_db, "Store.Categories"); }
public void ShouldDeleteACategoryWithTimestampData() { var category = CreateCategoryInstance("Foo"); _db.Categories.Add(category); _db.SaveChanges(); var db2 = new SpyStoreContext(); var catToDelete = new Category { Id = category.Id, TimeStamp = category.TimeStamp}; db2.Entry(catToDelete).State = EntityState.Deleted; var affected = db2.SaveChanges(); Assert.Equal(1,affected); }
public void ShouldNotDeleteACategoryWithoutTimestampData() { var category = CreateCategoryInstance("Foo"); _db.Categories.Add(category); _db.SaveChanges(); var db2 = new SpyStoreContext(); var catToDelete = new Category { Id = category.Id}; db2.Categories.Remove(catToDelete); var ex = Assert.Throws<DbUpdateConcurrencyException>(() =>db2.SaveChanges()); Assert.Equal(1,ex.Entries.Count); Assert.Equal(2,((Category)ex.Entries[0].Entity).Id); }