private static void updaterestauranttable()
        {
            restaurantdatalayer d1 = new restaurantdatalayer();

            d1.UpdateLocation(1, "tirur");
            d1.ShowAllRestaurants();
        }
        private static void insertdataintotable()
        {
            Restaurant          rt  = Setdata();
            restaurantdatalayer rd1 = new restaurantdatalayer();

            rd1.InsertRestaurant(rt);
            List <Restaurant> localliststr = rd1.ShowAllRestaurants();


            foreach (var s in localliststr)
            {
                Console.WriteLine("{0}\t{1}\t{2}\t{3}", s.Id, s.Rname, s.Rloc, s.Rating);
            }
        }
        private static void selectrow()
        {
            restaurantdatalayer d2 = new restaurantdatalayer();

            d2.ShowRestaurant(0);
        }