public HouseDTO AddUpdateHouse(HouseDTO u)
        {
            var newHouse = HouseMapper.DTOtoEntityHouse(u);

            db.Houses.AddOrUpdate(newHouse);
            db.SaveChanges();
            return(HouseMapper.EntitytoDTOHouse(newHouse));
        }
        public HouseDTO DeleteHouse(HouseDTO u)
        {
            var house = db.Houses.Find(u.CensusHouseNumber);

            house = db.Houses.Remove(house);
            db.SaveChanges();
            return(HouseMapper.EntitytoDTOHouse(house));
        }
        public HouseDTO GetHouseByID(int id)
        {
            var house = db.Houses.Find(id);

            return(HouseMapper.EntitytoDTOHouse(house));
        }