public void TestMethod1() { // database context worthingtonEntities db = new worthingtonEntities(); // act -- go get the first record Item savedItem = (from d in db.Items where d.ItemID == 1 select d).Single(); // assert Assert.AreEqual(savedItem.ItemID, 1); }
public void DeleteItem() { worthingtonEntities db = new worthingtonEntities(); Item myItem = new Item(); // first add an item I want to delete myItem.name = "Colfax Avenue"; myItem.type = 1; myItem.firstMentionBook = 0; myItem.firstMentionChapter = 18; db.Items.Add(myItem); db.SaveChanges(); Item deleteItem = (from d in db.Items where d.name == "Colfax Avenue" select d).Single(); db.Items.Remove(deleteItem); db.SaveChanges(); }
public void AddItem() { worthingtonEntities db = new worthingtonEntities(); Item myItem = new Item(); myItem.name = "Travis Wilder"; myItem.type = 0; myItem.firstMentionBook = 0; myItem.firstMentionChapter = 0; db.Items.Add(myItem); db.SaveChanges(); ItemDescription myDesc = new ItemDescription(); myDesc.bookNumber = 0; myDesc.description = "Travis Wilder is the owner of the Mine Shaft Saloon in Castle City, Colorado. He is tall, lean, and 33 years old. Travis has a beard, pale blond hair, and he wears wire-rimmed glasses."; myDesc.ItemID = myItem.ItemID; db.ItemDescriptions.Add(myDesc); db.SaveChanges(); }