public static void updateAuthor()
        {
            using (var context = new BooksDBEntities())
            {
                try
                {
                    //var try1= new Author();

                    Console.WriteLine("Enter Id to search:");
                    int id  = Convert.ToInt32(Console.ReadLine());
                    var upd = context.Authors.Find(id);


                    if (upd != null)
                    {
                        Console.WriteLine("Enter Author FirstName");
                        string fname = Console.ReadLine();


                        Console.WriteLine("Enter Author LastName");
                        string lname = Console.ReadLine();

                        Console.WriteLine("Enter Phone Details:");
                        string phone = Console.ReadLine();

                        Console.WriteLine("Enter Address:");
                        string address = Console.ReadLine();

                        Console.WriteLine("Enter City:");
                        string city = Console.ReadLine();

                        Console.WriteLine("Enter State:");
                        string state = Console.ReadLine();



                        upd.FirstName = fname;
                        upd.LastName  = lname;
                        upd.Phone     = phone;
                        upd.Address   = address;
                        upd.City      = city;
                        upd.State     = state;

                        Console.WriteLine("Inserted Successfully");
                    }
                    else
                    {
                        Console.WriteLine("Id doesn't exist");
                    }
                    context.SaveChanges();
                }
                catch (DbEntityValidationException e)
                {
                    Console.WriteLine(e);
                    throw;
                }
            }
        }
        public static void AddAuthors()
        {
            using (var context = new BooksDBEntities())
            {
                try
                {
                    var aut = new Author();


                    Console.WriteLine("Enter Author FirstName:");
                    var input = Console.ReadLine();


                    Console.WriteLine("Enter Author LasttName:");
                    string input1 = Console.ReadLine();

                    Console.WriteLine("Enter Author PhoneDetails:");
                    string inputPhone = Console.ReadLine();

                    Console.WriteLine("Enter Address:");
                    string inputAddress = Console.ReadLine();

                    Console.WriteLine("Enter City:");
                    string inputCity = Console.ReadLine();

                    Console.WriteLine("Enter State:");
                    string inputState = Console.ReadLine();


                    aut.FirstName = input;
                    aut.LastName  = input1;
                    aut.Phone     = inputPhone;
                    aut.Address   = inputAddress;
                    aut.City      = inputCity;
                    aut.State     = inputState;


                    context.Authors.Add(aut);
                    Console.WriteLine("Addedd Successfully");

                    context.SaveChanges();
                }
                catch (DbEntityValidationException e)
                {
                    Console.WriteLine(e);

                    throw;
                }
            }
        }