static void Main(string[] args) { Console.WriteLine("Welcome to AddressBook System program using ADO.NET"); ///Creating Instance object of AddressBookRepository class. AddressBookRepository repository = new AddressBookRepository(); ///UC1 Creating a method for checking for the validity of the connection. repository.EnsureDataBaseConnection(); /// UC2 Getting all the stored records in the address book service table by fetching all the records repository.GetAllContact(); /// UC 3: Adds the new contact into DB table. AddNewContactDetails(); /// UC 4 Ability to Edit the contactType of the existing contact. Console.WriteLine(repository.EditContactUsingName("Neha", "Singh", "Friend") ? "Update done successfully\n" : "Update failed"); /// UC5 Ability to Deletes the contact with given first name and last name. Console.WriteLine(repository.DeleteContact("Neha", "Singh") ? "Deleted Contact successfully\n" : "Update failed"); /// UC6 Retrieves the contacts from a given state or city. repository.RetrieveContactFromCityOrStateName(); /// UC7 Gets the count of people in a state or city. GetCountByCityOrState(); }