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);
        }