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);
}
}