public void SelectById() { CollectionItemManager manager = new CollectionItemManager(); //Variante 1: Alle Datensätze lesen und erstes Element auswählen und wieder lesen List <CollectionItem> itemList = manager.Select().ToList(); CollectionItem firstItem = itemList.FirstOrDefault(); if (firstItem != null) { CollectionItem item = manager.SelectById(firstItem.Id); Assert.IsNotNull(item); } else { Assert.IsNotNull(firstItem); } //Variante 2: Neues Element einfügen, ID feststellen und wieder lesen CollectionItem newItem = new CollectionItem(); newItem.Name = string.Format("CollectionItem SelectById {0}", DateTime.Now); newItem.Setnumber = "99999"; manager.Insert(newItem); Assert.AreNotEqual(newItem.Id, 0); if (newItem.Id != 0) { CollectionItem item = manager.SelectById(newItem.Id); Assert.IsNotNull(item); } }
public void Insert() { CollectionItem newItem = new CollectionItem(); newItem.Name = string.Format("CollectionItem {0}", DateTime.Now); newItem.Setnumber = "99999"; CollectionItemManager manager = new CollectionItemManager(); manager.Insert(newItem); Assert.AreNotEqual(newItem.Id, 0); }