Compact_ViewModel_20_10

 private Adressdaten addData = new Adressdaten();
        public Adressdaten AddData
        {
            get => addData;
            set
            {
                if (value != addData)
                {
                    addData = value;
                    RaisePropertyChanged();
                    ChangeAdressData = true;

                }
            }
        }


 private Adresstypen addtyp = new Adresstypen();
        public Adresstypen AddTyp
        {
            get => addtyp;
            set
            {
                if (value != addtyp)
                {
                    addtyp = value;
                    RaisePropertyChanged();
                }
            }
        }


 private void Adresstypenabfrage()
        {
            string abfrage = "Select * From Adress_Typ";
            SqliteConnection connect = zugriff.connect();
            SqliteCommand com = new(abfrage, connect);

            connect.Open();
            SqliteDataReader reader = com.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    Adresstypenliste.Add(
                        new Adresstypen
                        {
                            Adresstyp = reader.GetString(reader.GetOrdinal("Typ_Name")),
                            ID_Adresstyp = reader.GetString(reader.GetOrdinal("ID_Adress_Typ"))
                        });
                }
            }
        }


 private void Adressabfrage(string identify)
        {

            string abfrage = "Select a.ID_Adresse, Straße, Hausnummer, Postleitzahl, Ort, Land, at.Typ_Name FROM Adresse a JOIN Person_Adresse pa ON pa.ID_Adresse = a.ID_Adresse JOIN Adress_Typ at ON pa.ID_Adress_Typ = at.ID_Adress_Typ  WHERE ID_Person = @ID_Person";
            SqliteConnection connect = zugriff.connect();
            SqliteCommand com = new(abfrage, connect);

            SqliteParameter p1 = new();
            p1.ParameterName = "@ID_Person";
            p1.Value = identify;
            com.Parameters.Add(p1);

            connect.Open();
            SqliteDataReader reader = com.ExecuteReader();
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    Adressdatenliste.Add(new Adressdaten
                    {
                        ID_Adresse = reader.GetString(reader.GetOrdinal("ID_Adresse")),
                        Straße = reader.GetString(reader.GetOrdinal("Straße")),
                        Hausnummer = reader.GetString(reader.GetOrdinal("Hausnummer")),
                        Plz = reader.GetString(reader.GetOrdinal("Postleitzahl")),
                        Ort = reader.GetString(reader.GetOrdinal("Ort")),
                        Land = reader.GetString(reader.GetOrdinal("Land")),
                        AdressTyp = reader.GetString(reader.GetOrdinal("Typ_Name"))
                        //Etage = reader.GetString(reader.GetOrdinal("Etage")),
                        //Abteilung = reader.GetString(reader.GetOrdinal("Abteilung")),
                        //Gebäude = reader.GetString(reader.GetOrdinal("Gebäude")),
                    });
                }
            }
        }