public void TestReadRoomToSql()
        {
            var sql = "";
            var data = new RoomData();
            var mock = new Mock<DatabaseConnection>();
            var crud = new SqliteEquipmentCrud(mock.Object);

            mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s).Returns(() => new object[][] { new object[] { 1, "Kaffemaskiner" } });

            crud.Read(data.Rooms.First());

            Assert.AreEqual("SELECT Equipment.Id, Equipment.Name FROM Equipment JOIN Room ON Equipment.Id = Room.EquipmentId WHERE Room.Id = 1;", sql);
        }
        public void TestReadRoom()
        {
            var data = new RoomData();
            var mock = new Mock<DatabaseConnection>();
            var crud = new SqliteEquipmentCrud(mock.Object);

            mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Returns(() => new object[][] { new object[] { 1, "Kaffemaskiner" } });

            var equipments = crud.Read(data.Rooms.First());

            Assert.AreEqual(1, equipments.First().Id);
            Assert.AreEqual("Kaffemaskiner", equipments.First().Name);
        }