LINQ to SQL-update Method

1.

Public void updatefoods ()
{
Using (foodsdatacontext context = new foodsdatacontext ())
{
Food firstfood = (from F in context. Foods
Where F. ID = 1
Select f). First <food> ();
Firstfood. calories = 100;
Context. submitchanges ();
}
}

 

2.

Public bool updatecustomfood (Food customfood)
{
Bool result = false;
Using (datalayerdatacontext context = new datalayerdatacontect ())
{
Context. Foods. Attach (customfood, true );
Try
{
Context. submitchanges ();
Result = true;
}
Catch (changeconflictexception E)
{
// Handle the change conflict here
}
Return result;
}
}

 

3. you can either pass in both a copy of the new object along with the original or you can choose to have LINQ to SQL ignore concurrency altogether. here is the same update method that sends back a copy of the original object along with the updated version:

Public bool updatecustomfood (Food Original, Food updated)
{
Bool result = false;
Using (datalayerdatacontext context = new datalayerdatacontect ())
{
Context. Foods. Attach (original, false );
Original. Name = updated. Name;
Try
{
Context. submitchanges ();
Result = true;
}
Catch (changeconflictexception E)
{
// Handle the change conflict here
}
Return result;
}
}