public int RetriveContactByCityOrState(AddressBookModel addressBookModel) { using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand("SpRetriveContactByCityOrState", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@state_name", addressBookModel.state); connection.Open(); var Count = (int)command.ExecuteScalar(); SqlDataReader sqlDataReader = command.ExecuteReader(); if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { addressBookModel.person_id = sqlDataReader.GetInt32(0); Console.WriteLine("Number of Conctacts beloning to entered City Or State {0}", addressBookModel.person_id); } } return(Count); } }