Update database with LINQ to Entities
11,333
Try using db.SaveChanges();
public void updateRestaurant(int RestID, int HoursID, string Web, string Desc)
{
RestaurantsEntities db = new RestaurantsEntities();
RESTAURANT restDetails = (from RESTAURANT in db.RESTAURANTs
where RESTAURANT.REST_ID == RestID
select RESTAURANT).Single();
restDetails.HOURS_ID = HoursID;
restDetails.REST_WEBSITE = Web;
restDetails.REST_DESC = Desc;
db.SaveChanges();
}
Author by
Susan
Newbie ASP.Net developer having just received a 2-year degree from a technical college. Attempting to build commercial application using: ASP.Net 4.0, C#, membership provider, SQL, Linq to Entities. I am about 3/4 complete.
Updated on June 04, 2022Comments
-
Susan almost 2 years
I've been doing some research on how to update an existing record using LINQ, but I'm not having any luck. This is the method I've created - intellisense does not like the
db.SubmitChanges()
.public void updateRestaurant(int RestID, int HoursID, string Web, string Desc) { RestaurantsEntities db = new RestaurantsEntities(); RESTAURANT restDetails = (from RESTAURANT in db.RESTAURANTs where RESTAURANT.REST_ID == RestID select RESTAURANT).Single(); restDetails.HOURS_ID = HoursID; restDetails.REST_WEBSITE = Web; restDetails.REST_DESC = Desc; db.SubmitChanges(); }