public void InsertDeleteValidateGetUserOwnsSystemTest() { var db = new PlantRepository(); var plantId_1 = DatabaseHelpers.CreatePlantGetId(); var plantId_2 = DatabaseHelpers.CreatePlantGetId(); //Insert test data db.StoreUserPlantRelation(3, plantId_1, E_PlantRole.Owner); db.StoreUserPlantRelation(2, plantId_2, E_PlantRole.Guest); //validate Assert.True(db.ValidateUserUserForPlant(3, plantId_1, E_PlantRole.Owner)); Assert.True(db.ValidateUserUserForPlant(3, plantId_1, E_PlantRole.Guest)); Assert.True(db.ValidateUserUserForPlant(2, plantId_2, E_PlantRole.Guest)); Assert.False(db.ValidateUserUserForPlant(2, plantId_2, E_PlantRole.Owner)); //get owners var actual = db.GetUsersOfSolarPlant(plantId_2, E_PlantRole.Guest); Assert.AreEqual(1, actual.Count); Assert.AreEqual(2, actual[0]); //delete relationship db.DeleteUserHasPlantRelation(2, plantId_2, E_PlantRole.Guest); Assert.False(db.ValidateUserUserForPlant(2, plantId_2, E_PlantRole.Guest)); }