public override bool Equals(object obj) { if (obj == null) { return(false); } CapitalCity countr = obj as CapitalCity; if (countr == null) { return(false); } return(this.Id == countr.Id); }
public object GetCountryAndItsCapitalCityDetails(int countryId) { SQLiteConnection con = new SQLiteConnection("Data Source = C:\\Users\\itsvibel\\Downloads\\SQL_Tirgul; Version = 3;"); con.Open(); using (SQLiteCommand cmd = new SQLiteCommand("SELECT * From COUNTRY JOIN CAPITALCITY ON COUNTRY.CAPITALCITY_ID == CAPITALCITY.ID WHERE COUNTRY.ID == {countryId}", con)) { // execut4e the query into the reader using (SQLiteDataReader reader = cmd.ExecuteReader()) { // use the reader to read all of the results of the query while (reader.Read() == true) { Country Countr = new Country { Id = (int)reader["COUNTRY_ID"], Name = (string)reader["NAME"], Size_km = (int)reader["SIZE_KM"], Birth_Year = (int)reader["BIRTH_YEAR"], CapitalCity_Id = (int)reader["CAPITALCITY_ID"] }; CapitalCity City = new CapitalCity { Id = (int)reader["ID"], C_Name = (string)reader["NAME"], NumCitizens = (int)reader["NUMCITIZENS"], Country_Id = (int)reader["COUNTRY_ID"] }; var results = new { Countr.Id, Countr.Name, City.C_Name, City.NumCitizens, City.Country_Id }; con.Close(); return(results); } } } return(null); }